Skip to main content

MSSQL database restoration to different database

MSSQL database restoration to different database

You can get a range of different problems when trying to restore an MSSQL database to a different database.  There are also a range of different solutions However, the following steps  work for me. 

These steps require MS SQL Management Studio.  
  1. In MS SQL Management Studio, create the target database, make note of the location of the database file and log file.
  2.  Start the restore process and select the appropriate backup file and backup date
  3. On the "Restore Database" dialog, on the "General" tab, under "Destination" select the desired target database.
  4. Select the "Files" tab.  Within the "Files" tab, you'll see that the data and log file are pointing to the old database, change both the data and log file to be the database you created in step 1
  5. In "Options", select the "Overwrite" option (WITH REPLACE)

Comments

Post a Comment

Popular posts from this blog

Javascript Form Validation

It's real simple. All you need to do is call a javascript function in a html  " onsubmit " in the form tag as a javascript return, like this       <form method="post" action="dosomething.php" onsubmit="return validateForm();"> If the code completes ok, the form is then sent to the page listed in "action" http://www.w3schools.com/js/js_form_validation.asp If the function specified in the onsubmit returns false, then the form is not sent to the page mentioned in action.
Post a Comment
Read more