CompTIA
Exam Vouchers
Save money on CompTIA exams
| Question of the day
Sign up to receive
interactive practice questions
for MCSE, CompTIA
Cisco and other exams
| TestKing
Get MCSE, MCSD, CCNA, CCNP,A+, N+ and many more | * ExamSheets *
Guide for Success!
Actual Questions & Answers
MCSE, MCSD, A+ ,CCNA, CCNP
Oracle 8i, Oracle 9i Online practice tests
Certification sites Online university Online college Online education Distance learning Software forum Server administration forum Programming resources
|
|  |
| Author |
Restoring from raw files
|
Brian Kirkpatrick
Guest
Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:
Total Posts: N/A
|
|
 Restoring from raw files
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
Report this post to a moderator
|
|
 06-28-02 09:25 PM
|
|
Tom Moreau
Guest
Registered: Not Yet
Location:
Country:
State:
Certifications:
Working on:
Total Posts: N/A
|
|
|
Re: Restoring from raw files
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
Report this post to a moderator
|
|
|
06-28-02 10:25 PM
|
|
|
Featured site: MCSE, MCSD, CompTIA, CCNA training videos
Forum Rules:
Who Can Read The Forum? Any registered user or guest.
Who Can Post New Topics? Any registered user.
Who Can Post Replies? Any registered user.
Changes: Messages can be edited by their author.
Posts: HTML code is OFF. Smilies are ON. vB code is ON. [IMG] code is OFF. |
|
ExamNotes forum archive
|
