|
Home > Archive > microsoft.public.sqlserver.server > June 2002 > Restoring from raw files
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 from raw files
|
|
| Brian Kirkpatrick 2002-06-28, 4:25 pm |
| I have a backup of a machine, however the operator didn't create .bak files for the SQL. I don't know much about SQL myself, but is there a way to make the SQL application and Master database (I think) "see" the
.ldf, and .mdf files we already have? If not, is there a way to dump the .ldf, and .mdf files into .bak files, for easy SQL restoration?
-Brian
| |
| Tom Moreau 2002-06-28, 5:25 pm |
| Check out sp_attach_db in the BOL.
--
Tom
----------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
www.apress.com
---
Brian Kirkpatrick wrote in message <1103_1025301919@msnews.microsoft.com>...
I have a backup of a machine, however the operator didn't create .bak files
for the SQL. I don't know much about SQL myself, but is there a way to make
the SQL application and Master database (I think) "see" the
ldf, and .mdf files we already have? If not, is there a way to dump the
..ldf, and .mdf files into .bak files, for easy SQL restoration?
-Brian
|
|
|
|
|