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 2005 Forums
 SQL Server Administration (2005)
 backup taking long time

Author  Topic 

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2011-03-16 : 04:25:42

Hi All,

Am trying take a full backup of sharepoint database which is of 40 GB size.Am using management studio and sql server 2005 sp3 Enterprise edition. OS is Windows server 2003.It worked fine for 20% and from past 2 hours it has been in hung state. I dont really know what is happening in the background.

Is there any we can observe at OS level or any command is there to check the progress of the backup is happening in the background.

How to check the progress of this backup? I dont know if i can really KILL the process and if i start again may be i might landup in the same situation.

Any efficient way to complete this full backup in a timely fashion???

Thanks in Advance.

   

- Advertisement -