Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 how to drop the instance and recreate with the ba

Author  Topic 

sql4us
Starting Member

24 Posts

Posted - 2011-11-15 : 11:23:49
How to drop the instance and create the new one with the backup files?

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-11-15 : 11:29:14
Drop the instance (as in uninstall SQL Server) or drop a database?

--
Gail Shaw
SQL Server MVP
Go to Top of Page

sql4us
Starting Member

24 Posts

Posted - 2011-11-15 : 11:32:05
I have Database\instancename, SO I just want to drop the instance and recreate the same instance and copy the files from that backup..
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-11-15 : 12:56:58
That would require you to uninstall SQL Server and then reinstall it, then restore all your system databases, then restore or attach all your user databases.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -