Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
duhaas
Constraint Violating Yak Guru
310 Posts |
 Posted - 2007-02-07 : 14:19:40
|
| In doing some test, why does it appear when I run the following:restore database IMCMFTPfrom disk = 'e:\imc.bak'with move 'IMCMFTP_Data' TO 'e:\imcmftp.mdf',move 'IMCMFTP_Log' to 'e:\imcmftp.ldf'I get these resultsRESTORE DATABASE successfully processed 463933 pages in 108.509 seconds (35.025 MB/sec).but in reality the query took 3:47 but the out shows 108 seconds??? |
|
|
rcurrey
Starting Member
30 Posts |
Posted - 2007-02-07 : 14:40:48
|
| If it's a server and there are other processes running, it may not have dedicated 100% of its processing ability to the task. This results in a longer "real time" than "processing time".Thanks,Rich |
 |
|
|
duhaas
Constraint Violating Yak Guru
310 Posts |
Posted - 2007-02-07 : 15:06:53
|
| sql is the only application running on this server, just have never seen that before, although dont usually do restore from commandline, usually use gui. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-08 : 07:56:11
|
| Might be showing the restore time, but excluding the time to prepare the MDF file [before the restore starts]. That always seems to me to take quite a while ...restore database IMCMFTPfrom disk = 'e:\imc.bak'with STATS = 1,move 'IMCMFTP_Data' TO 'e:\imcmftp.mdf',move 'IMCMFTP_Log' to 'e:\imcmftp.ldf'would give you a bit of an idea when the real restore started ...Kristen |
|
|
|
|
|
|
Backup Times