June 5, 2009 at 4:03 am
when i am trying to restore a database from a backup ,it is showing 2 mdf file and 2 ldf file ...wat is this????????
June 5, 2009 at 4:08 am
You can use RESTORE FILELISTONLY which will return list of the database and log files contained in the backup. If your backup have 2 data file and 2 log file there is no issues you can go ahead and restore your DB.
You need to read BOL for information on Backup & Restore
"More Green More Oxygen !! Plant a tree today"
June 5, 2009 at 4:13 am
There is one backup appended to the other? Pick the most recent.
When you say there's two mdf and two ldf files in there, what tool are you using to look inside the .bak file?
June 5, 2009 at 4:24 am
restoration process is taking so much time...not even showing progress bar for half an hour
June 5, 2009 at 4:31 am
What is the size of the backup file? Is SQL Server with SP2?
"More Green More Oxygen !! Plant a tree today"
June 5, 2009 at 4:37 am
Check out:
http://msdn.microsoft.com/en-us/library/aa238420(SQL.80).aspx
http://msdn.microsoft.com/en-us/library/aa238405(SQL.80).aspx
If there are 2 data file and 2 log file its not an issue
The extra files will be created when you restore the database.
Tanx 😀
June 5, 2009 at 4:42 am
If there are 2 backup files, they'll be same or of different versions.
restore the lastest database backup file, it may take time (more than 1 hour) to restore if your data size is large (say 20-25 GB).
June 5, 2009 at 5:38 am
sql 2000 standard edition...backup file is 20 gb
June 5, 2009 at 6:47 am
It just sounds like a databse with two data files & two log files. Make sure, if you're restoring it to a new server, you get all four files into the MOVE statements and you should be fine.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply