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)
 Script for Force Restore

Author  Topic 

abhwhiz
Starting Member

37 Posts

Posted - 2007-09-04 : 01:10:55
I am doing a force restore on a db, my doubt is, when i use a script to do so, how it wld look like?

RESTORE DATABASE <db> FROM DISK <path> WITH MOVE <NAME> TO <NEW PATH><FILENAME>,MOVE ...., REPLACE

like this? Please help me. Thanks in advance.

Kristen
Test

22859 Posts

Posted - 2007-09-04 : 04:03:04
Does this answer your question?

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=RESTORE%20syntax%20/%20example

Kristen
Go to Top of Page

abhwhiz
Starting Member

37 Posts

Posted - 2007-09-04 : 05:27:52
Kristen,

Thnx m8..thats an awesome collection ..wow!!! thanks a lot for the stuff..
But i couldnt find the thing i wanted...(or did I miss it..?) and i found it here
[url]http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1173442,00.html[/url]

Once again thanks for that link you gave.
Go to Top of Page
   

- Advertisement -