Restore DB takes too much time.

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Restore DB takes too much time.

Author

Topic

Sarat
Constraint Violating Yak Guru

265 Posts

Posted - 2002-09-04 : 11:48:38

Hi,
The restore database process from one server to another (even on the server) for my 14 GB database (12 GB backup file) takes 20-40 mins. We are upgrading to a new version of software (web based) and now my database size is 18 GB (15 GB backup file). Now it take 7 hours for restore!!!!! Why is there a such a drastic difference?
What could have changed? Because I can still do refreshes in 40 mins for my old 14 GB database!
Thanks,
Sarat.

Sarat
Constraint Violating Yak Guru

265 Posts

Posted - 2002-09-04 : 12:33:11

Hey Guys,
I did this test and it was successful.

1. I was trying to restore database on the same server but I was using \\DTC_PSTST\Q$\ instead of direct drive letter Q:\. So when I used Q:\ drive letter as it is, it works just faster and fine!!

2. It still worked faster when I restored database accross the server using \\ServerName.

So, I am forced to conclude that if I use \\ServerName notation to restore db on the same server, it takes longer time so I should use drive letter!! WHY?

--
This SQL - took longer time
RESTORE DATABASE HR8TST
FROM DISK = '\\DTC_PSTST\Q$\Program Files\Microsoft SQL Server\MSSQL\Backup\RequestBak\hr8prd_090302.bak'
WITH MOVE 'HR8PRD_Data' TO 'Q:\Program Files\Microsoft SQL Server\MSSQL\Data\HR8TST_Data.mdf',
MOVE 'HR8PRD_Log' TO 'S:\Program Files\Microsoft SQL Server\MSSQL\Log\HR8TST_Log.ldf',
STATS = 2
GO

--Vs This (took 20 mins)

RESTORE DATABASE HR8TST
FROM DISK = 'Q:\Program Files\Microsoft SQL Server\MSSQL\Backup\RequestBak\hr8prd_090302.bak'
WITH MOVE 'HR8PRD_Data' TO 'Q:\Program Files\Microsoft SQL Server\MSSQL\Data\HR8TST_Data.mdf',
MOVE 'HR8PRD_Log' TO 'S:\Program Files\Microsoft SQL Server\MSSQL\Log\HR8TST_Log.ldf',
STATS = 2

-- END
Thanks,
Sarat

royv
Constraint Violating Yak Guru

455 Posts

Posted - 2002-09-04 : 14:34:42

I cannot give you a specific answer to your problem, I just wanted to say that I also have run into weird errors with SQL Server when using UNC over mapped drives. Apparently SQL Server is not too fond of UNC.

*************************
Someone done told you wrong!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources