Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 53
  • Last Modified:

Restore Procedure question

I have an instance that houses both  the production and the test database of the same app

production db name = frliv
test db name = test

the sql server is 2008.
normally i will grab the backup files off of the network share and restore the test database from the "restore from file" option for this process

this time i would like to click on the frliv database and use the restore database function and point it to the proper restore database and the proper restore "test" files

i haven't done this before so i want to make sure that nothing will happen to the frliv (prod) database if i go this route.

Can someone confirm that this process is ok to use.

Attached is a screenshot with details

thanks a bunch
Restore-Process-outlined-for-expert.docx
0
jamesmetcalf74
Asked:
jamesmetcalf74
  • 2
2 Solutions
 
lcohanDatabase AnalystCommented:
The document and implicit the steps in it looks OK however I suggest do one more thing for at least 2 reasons:
1. most important in my opinion is that you will SEE 100% what SQL does/runs and you can change it and save it if/as needed for future use.
2. you will see the process running in SSMS query message result tab and always better control if needed to be canceled VS the UI code.

So I suggest just hit that "Script" button besides the "Help" and generate SQL for the whole restore then run that SQL instead of restore via the UI.
0
 
Scott PletcherSenior DBACommented:
I'd very strongly recommend forgetting the gui/click method of restoring.

Instead, always use a RESTORE command.  The command can be generated from system metadata if you want to make it easier.  Among other benefits, that would (1) drastically reduce the chance of error; and (2) insure that if there are issues you would know later exactly what restore was done.

I can post a sample script to generate the RESTORE command if you would like.
0
 
jamesmetcalf74Author Commented:
Maybe in the future i could get accustomed to using the scripting method.  I need to complete this restore in the next hour or so....
with that time constraint in mind...
i should be ok to use the method i outlined?
can you please post the script anyway Scott?
0
 
lcohanDatabase AnalystCommented:
All you need to do is to hit that script button and look all code details that will show on your screen to make sure the database is restored as you want as "Test". It's the easiest way to double check that you have nothing wrong selected in the UI like a "overwrite" of the Production database.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now