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.
| Author |
Topic |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2008-05-01 : 11:24:18
|
| RESTORE DATABASE myDB...?---http://www.ssisdude.blogspot.com/ |
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2008-05-01 : 13:23:14
|
| Books Online: RESTORE |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-01 : 13:44:21
|
| RESTORE DATABASE myDBFROM DISK = '\\someremoteserver\someshare\myDB.bak'WITH REPLACETara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-05-01 : 14:10:00
|
| Thank you Tara, it was a LiteSpeed backup, that's why it wasn't working...---http://www.ssisdude.blogspot.com/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-01 : 14:10:53
|
| Well you can't run RESTORE DATABASE with a LS backup. Make sure you include that very important information in any future posts as it makes a difference if you are using native or LS backups.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-05-01 : 14:28:52
|
| Yeah, I didn't know until I asked a co-worker.For future reference, LiteSpeed uses a command called, EXEC xp_restore_database to restore databases.---http://www.ssisdude.blogspot.com/ |
|
|
|
|
|
|
How do I restore a DB across the network?