• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 174
  • Last Modified:

restoring sql database from backup

I have sql 2005 and im using microsoft sql server managment studio on a windows 2008 server.

i have done test restores before where i restored backups to a different database name.
this time i have to restore foreal.....

so for instance.
i have to restore the current database "medical" back to a week from today. but i need to restore it as medical.
do i delete the current medical or rename it.  then restore the back up to medical.
whats the best way to restore a current in use database?

delete or rename active database or something different?
2 Solutions
You have several options, but assuming that you just want to replace the existing database, you go through the restore wizard and select the option to "Overwrite Existing Database"

More info: http://msdn.microsoft.com/en-us/library/ms177429.aspx
Chris MConsulting - Technology ServicesCommented:
For sure if you do not need the current database, you could delete it first, then perform a restore.
Optionally, (in case you do not want to delete the database first) you can restore with the option (overwrite existing database) in SQL server management studio.

Either way, the choice is yours :-)

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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