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 |
|
sergei_p
Starting Member
1 Post |
 Posted - 2003-06-23 : 04:34:49
|
| Hi Is ist possible to restore a sql2000 db without having the data file ? I only have the log. thanks Edited by - sergei_p on 06/23/2003 04:40:51 |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2003-06-23 : 07:57:04
|
| restore or attach ?You cannot attach files if you only have the log (ususally named .ldf)- you need the data file(ususally named .mdf). Restoring from a backup (usually named .bak) can be done, assuming you have the correct files. You don't need the data file or the log file, but you will need the full backup, and then, if necessary, the relevant differential and/or transaction log backup file. Refer to BOL (books online) for Restore syntax.HTH*#&#* *#&#* *#&#* *#&#* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-06-23 : 12:30:15
|
| Do you have a backup file to restore?The .LDF is of no use by itself.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-06-23 : 12:36:33
|
| Sounds like a career change is on it's way....Brett8-) |
|
|
|
|
|
|
database restore