Edit the below to use your existing file/database name and file
locations. This will restore your database from your backup. Keep in
mind your database will be restored up to the date and time of your
backup. Any activity that occurred after the backup will be lost.

-- login as SA use master
Restore database mydatabase
from disk = 'd:\mssql\backup\mydatabase.bak'
with recovery,

Move 'mydatabase_Data' to 'd:\mssql\data\mydatabase_Data.mdf',
Move 'mydatabase_Log' to 'd:\mssql\data\mydatabase_Log.ldf'

-----Original Message-----
From: Kaustubh Puranik [mailto:Kaustubh.[Email Address Removed]
Sent: Monday, August 18, 2003 2:54 PM
To: LazyDBA.com Discussion
Subject: Restore Databse


Hi All,

I am having the backup (.bak file) of my database. My existing databse
is currupt and no longer exists into the enterprise manager/database.
The .MDF and .LDF files are exists but are currupted. Is there any way
to restore the database from .bak file. I never had this kind of problem
before so please provide all details..

Thanks a lot....

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To
unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional
commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page