April 9, 2007 at 9:13 am
i have a maintenance plan to have full backup of about 100 gb database. the database have 2 data and 2 log file. when i try to restore it
1. restore operation is running for hours, with no progress bar. only thing i can see is two data file created in the target location.
2. both data files have same (mdf) extension. in real db secondary file is ndf and the default file group is not the primary.
3. log file is not created in target location (in fact no where in that machine).
what can be the reason for this situation. and how to solve it.
April 9, 2007 at 8:03 pm
Did you write the statement with "with norecovery" ?
April 10, 2007 at 1:42 am
i am restoring with enterprise manager..so where to specify norecovery and what the use of this option.
April 10, 2007 at 7:26 am
In the options Recovery State you should see the Leave the database non operational option. But I recommend you do this with script from query window, that way you have control of where the data files and log files should be restored and physical file names also and use STATS to see the percentage of the progress. Of course check the SQL BOL for any reference first.
here is the link for SQL server 2005 BOL search.
http://search.live.com/macros/sql_server_user_education/booksonline
Good day
Bulent
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply