Post reply

Backup

  • December 4, 2006 at 12:10 am

    #115197

    Hi All,

    I just want to find out if there is way for me to backup my database on another sever on the network. If so how do I do it as I have tried several times with no success.

    I thank you in advance.

     

  • December 4, 2006 at 12:41 pm

    #675581

    Kind of yes. SQL Server doesn't like that since it can't guarantee the network drive will be available when it does the backup. However, I have heard that you can use the UNC qualification to identify a network drive.

    -SQLBill

  • December 4, 2006 at 12:50 pm

    #675588

    Yes, as long as sql can see that server with write access..

    I do this all the time...

    Backup database dbname to disk = '\\servername\c$\dbname.bak' with init, stats=10

     

    MohammedU
    Microsoft SQL Server MVP

  • December 4, 2006 at 2:41 pm

    #675632

    Yes, you can. But you need a stable network when a huge database is either backing-up or restoring.

  • December 5, 2006 at 12:42 pm

    #676008

    You also need to ensure that the account that is running the MSSQLSERVER service is a domain account with write permissions to the network device.  When performing a backup it is not the account that you login to SQL Server with that applies it is the account that runs the SQL Server service. 

    I have also found that UNC paths work better than mapped drives for availability and performance reasons.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply