locked
Backup and Restore Database on network in SQL Server 2005 RRS feed

  • Question

  • i don't know much about Networking . i know how to backup database in local drive in a computer but i want to take backup into other computer every day .

    We have two Servers A and Serve B in our organization , my Pc is connected in Server B

    what are the steps i have to do ?


    Sunday, December 19, 2010 3:11 PM

Answers

  • Backing up databases into a network shared folder is same as performing the backup into a local disk.
    Use syntax like this

    BACKUP DATABASE db_name TO DISK='\\serverA\shared_folder_name\db_name_backup.bak'

    But onething you must make sure before you run this command in SQL server is that your SQL server service account must be having write access in the shared folder - If your SQL server service is running under a domain account please folder level grant access and then initiate the backup process.


    Thanks, Leks
    • Proposed as answer by PrinceLucifer Monday, December 20, 2010 6:40 AM
    • Marked as answer by WeiLin Qiao Monday, December 27, 2010 6:10 AM
    • Edited by Lekss Monday, December 27, 2010 9:32 PM Spelling error
    Monday, December 20, 2010 12:17 AM

All replies

  • This article looks at backing up a database to  a network share;

     

    http://www.mssqltips.com/tip.asp?tip=1126


    Gethyn Ellis blog: http://www.gethynellis.com/
    Sunday, December 19, 2010 7:39 PM
  • Backing up databases into a network shared folder is same as performing the backup into a local disk.
    Use syntax like this

    BACKUP DATABASE db_name TO DISK='\\serverA\shared_folder_name\db_name_backup.bak'

    But onething you must make sure before you run this command in SQL server is that your SQL server service account must be having write access in the shared folder - If your SQL server service is running under a domain account please folder level grant access and then initiate the backup process.


    Thanks, Leks
    • Proposed as answer by PrinceLucifer Monday, December 20, 2010 6:40 AM
    • Marked as answer by WeiLin Qiao Monday, December 27, 2010 6:10 AM
    • Edited by Lekss Monday, December 27, 2010 9:32 PM Spelling error
    Monday, December 20, 2010 12:17 AM