What would be the best solution for backup?

Question

Hi,
Our full bakup has been failing for last 4 weeks because of insufficent disk space. Now we have the accumulated transactional and differential backups. We need to take full backup but the disk space is not sufficient. What would be the best solution to get full backup?

Thanks.

Answer 1

Hi

You can set up a share on a file server and take the full backup over the network.

The permisson on the share must have the same account on it witch you start the SQL Server service with

Then you just run the BACKUP command

BACKUP DATABASE [your database] TO DISK '\\FILESERVER1\SHARE1\YOURDatabase.bak'

Hope it works for you
Best regards

---

Jens Nilsson MCTS - SQL Server 2008 Imp. and Main.

Answer 2

Nilsson,
 it could have been done. but this server is in cluster which operates in different account and if i change the service account then it will bring down the server.

Any other options??

Thanks

Answer 3

If you cant follow Nilsson's approach, can't request for additional space and don't have any third party tool to take backup on tape then you dont have any option left.


Thanks,
Nimit

Answer 4

Hi again

You do not have to change the service account in the cluster, just make sure that the account that the SQL Server uses in the cluster have modify permissions on the share.

Best regards

---

Jens Nilsson MCTS - SQL Server 2008 Imp. and Main.