February 27, 2009 at 8:58 am
Mistakenly deleted database data and log files.
Can the files be recreated, how can we restore the data and log files
very urgent
February 27, 2009 at 9:14 am
Do you have database backups?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 27, 2009 at 9:16 am
Do you have a backup?
maybe check your recycle bin?
February 27, 2009 at 9:37 am
I have my backups and some databases within the sql server are still running while the one i just shut down cannot start.
February 27, 2009 at 9:39 am
Cant backup the system database but all other databases are backup.
February 27, 2009 at 9:41 am
solution_developer (2/27/2009)
Cant backup the system database but all other databases are backup.
You can and should backup the system databases.
Since you have a backup of your missing datafile database, then it looks like you should be fine. Resotre the backup and logs and recreate your database.
February 27, 2009 at 9:44 am
How can i restore the .bak file to .mdf and ldf
February 27, 2009 at 10:08 am
Check out RESTORE in BOL (books on line). Basic Syntax is:
Restore Database [db name] From Disk='path to backup' with MOVE '[data file logical name]' to '[data path]',
MOVE '[log file logical name]' to '[log path]'
This will create the database and the mdf and ldf files.
Edit: Originally forgot to put the word "Database" in the restore statement after "RESTORE".
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply