Home > Archive > Microsoft SQL Server forum > September 2005 > Restoring a missing db









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Restoring a missing db
John

2005-09-27, 8:24 pm

Hi

sql server 2005. Is there any way to restore from a backup if the original
db has been deleted? I have created a blank db and have tried to restore
into it but it says the db is not the same.

Thanks

Regards



David Portas

2005-09-27, 8:24 pm

You should ask SQL Server 2005 questions in the 2005 groups:
http://communities.microsoft.com/ne...welcomePage.htm

You don't need to create an empty database in order to RESTORE. If you do
that then you'll need to use the REPLACE option in order to replace the
database.

--
David Portas
SQL Server MVP
--


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com