Results 1 to 2 of 2

Thread: Restore of Prodcution DB to Test DB On Another Server

  1. 10-01-2006, 02:35 PM #1
    vaddi
    vaddi is offline Registered User
    Join Date
    Sep 2006
    Posts
    4

    Restore of Prodcution DB to Test DB On Another Server

    Hello

    Can anybody give me an idea or a script which can be used to Restore a production Database to Test Database on another server. As I need to do this 3 days a week, I would like to make this automated.

    Thanks
    Reply With Quote Reply With Quote
  2. 10-01-2006, 05:52 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You can run this as scheduled job:

    restore database db_name from disk = '\\host_name\share\file_name' with ...

    You have to start sql agent service with domain account that has permission to read backup file, and may need use move option in restore statement if db file path is different on those servers.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules