locked
What would be the best solution for backup? RRS feed

  • 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.
    Wednesday, July 29, 2009 12:17 PM

Answers

  • 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.
    Wednesday, July 29, 2009 12:47 PM
  • 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.
    Thursday, July 30, 2009 8:23 AM

All replies

  • 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.
    Wednesday, July 29, 2009 12:47 PM
  • 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

    Wednesday, July 29, 2009 12:59 PM
  • 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
    Thursday, July 30, 2009 2:20 AM
  • 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.
    Thursday, July 30, 2009 8:23 AM