September 7, 2007 at 2:33 pm
I have the following QA code to restore a database that is made up of 1 MDF file, 5 NDF files, and 1 LDF file:
restore database dia2 FILEGROUP = 'PRIMARY'
from disk = 'e:\diabackup\PRIMARY_2007_08_31_02_35_22.BAK'
with norecovery
restore database dia2
FILEGROUP = 'DIA_DLY'
from disk = 'e:\diabackup\DIA_DLY_2007_08_31_02_11_31.BAK'
with norecovery
restore database dia2
FILEGROUP = 'DIA_DI090'
from disk = 'e:\diabackup\DIA_DI090_2007_08_31_02_22_35.BAK'
with norecovery
restore database dia2
FILEGROUP = 'DIA_DI010'
from disk = 'e:\diabackup\DIA_DI010_2007_08_31_02_23_32.BAK'
with norecovery
restore database dia2
FILEGROUP = 'DIA_DI030'
from disk = 'e:\diabackup\DIA_DI030_2007_08_31_02_33_56.BAK'
with norecovery
restore database dia2
FILEGROUP = 'DIA_MTHLY'
from disk = 'e:\diabackup\DIA_MTHLY_2007_08_31_02_41_05.BAK'
with norecovery
restore log DIA2
--filegroup = 'dia_log'
from disk = 'e:\diabackup\DIA_LOG_2007_08_31_02_53_34.BAK'
with recovery
--********************************************************
When I run it, this is the result:
Processed 435664 pages for database 'dia2', file 'dia2_Data' on file 1.
RESTORE DATABASE successfully processed 435664 pages in 66.252 seconds (53.869 MB/sec).
Processed 315120 pages for database 'dia2', file 'DIA2_DLYDATA' on file 1.
RESTORE DATABASE successfully processed 315120 pages in 46.482 seconds (55.536 MB/sec).
Processed 78480 pages for database 'dia2', file 'DIA2_DI090' on file 1.
RESTORE DATABASE successfully processed 78480 pages in 14.090 seconds (45.628 MB/sec).
Processed 1182152 pages for database 'dia2', file 'DIA2_DI010' on file 1.
RESTORE DATABASE successfully processed 1182152 pages in 215.525 seconds (44.933 MB/sec).
Processed 169296 pages for database 'dia2', file 'DIA2_DI030' on file 1.
RESTORE DATABASE successfully processed 169296 pages in 26.604 seconds (52.130 MB/sec).
Processed 988936 pages for database 'dia2', file 'DIA2_MTHLY' on file 1.
RESTORE DATABASE successfully processed 988936 pages in 178.520 seconds (45.380 MB/sec).
Processed 11 pages for database 'DIA2', file 'dia2_Log' on file 1.
Server: Msg 3624, Level 20, State 1, Line 30
Location: filemgr.cpp:1764
Expression: IS_ON (FCB_LOG_DEVICE, saflStatus) || IS_ON (FCB_DROPPED, saflStatus)
SPID: 51
Process ID: 3240
Connection Broken
It seems to get hung up on my log file.
Any ideas would be appreciated.
Thanks!!!
October 1, 2007 at 9:45 pm
Sounds like your log file might have problems. Have you checkdisk'd the drive? Maybe move the log file off and back to make sure there are not bad blocks.
It could be corrupt, which wouldn't be good. You might try recreating the db with a new log file (new db name) and then restoring to check that as well.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply