I could install SQL server using service account created by one of my team who have access to Devadmin.

Thanks!

Thanks. I am already using service account to install hope this works.

If DB size is 15 GB then i would keep my log to 4GB .There will not be any issue with shrinking the log you have lot of free space...

What is the size of the database generally log should be 25-30% of database size. If your database is in full /Bulk logged recovery model take log backup and shrink...

I don't have rsync installed on my servers while the Resource Kit with robocopy is often installed (or at least it's on an "approved" list of software that can be...

I had the similar issue job which was taking under three hours to complete started taking 48 hours or more ultimately I had to terminate(kill) the job as it was...

what is the tool you are using to copy the file across is it xcopy or robocopy? robocopy is faster and efficient.

Did you try Import/export option of SQL when server is not too busy?

Is there enough disk space space avaialble on your source drive?

thank you all.

History did not give enough informatiom but Indepth did show bit more about performace of the SP. And development tema is looking at it now.

Thanks again

Thank you all for the helpul/quick inputs:) much appreciated!

Thanks you all for your inputs with the help of SAN team reports I could calculate the disk space required.

Thanks again

full backups taken every day (deleteing old backup file from previous night) .Backups are copied daily to tape.

db size is around 800GB and Litespeed backup file size is around 450...

Thanks Kevin.

I ‘d certainly update you on the progress of this project we might end up having MS DSE assisting us .

Here is one more requirement from the Project which...

Thanks!