backup and restore

Answers

• 

  

  0

  Sign in to vote

  First step: backup database in production. this will build a bak file. you can get help in this links:
  http://technet.microsoft.com/en-us/library/ms191304(v=sql.105).aspx
  http://www.serverintellect.com/support/sqlserver/database-backup-ssmse/
  
  step 2: move the file to your home server. you can use any flash drive, disk, or connect using FTP. just chose any way that you like to move a file from one computer to the other
  
  step 3: restore data base. you can get help in this links:
  http://technet.microsoft.com/en-us/library/ms189895(v=sql.105).aspx
  http://www.youtube.com/watch?v=WCQbOxbu4V4

  * while restoring you do not need to connect to the production. you can close the connection to internet... you only need the backup file/files

  ---

  [Personal Site] [Blog] [Facebook]

  • Proposed as answer by Shanky_621MVP Monday, October 28, 2013 3:58 AM
  • Marked as answer by Allen Li - MSFT Friday, November 1, 2013 9:26 AM

  Sunday, October 27, 2013 9:16 PM
• 

  

  0

  Sign in to vote

  Hi,

  I have a scenario that I want to restore the database from production server to the development server both are located in different domains. While restoring how can i connect to the prod server for backup files or how can i use the backup files for restoring.
  

  Hello Surya,

  Copy the bak file to the desired server and run restore command

  use master
  go
  alter database db_name set single_user with rollback immediate
  go
  restore database db_name from disk='location\back.bak'
  with recovery

  
  

  ---

  Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

  
  

  • Edited by Shanky_621MVP Monday, October 28, 2013 4:08 AM
  • Proposed as answer by Heidi-Duan Tuesday, October 29, 2013 9:45 AM
  • Marked as answer by Allen Li - MSFT Friday, November 1, 2013 9:26 AM

  Monday, October 28, 2013 4:01 AM