Monday, May 02, 2011

How to find the status of Backup / Restore in SQL Server 2000


To know the status of backup or restore in SQL Server 2000 ;

1. Find the SPID which is restoring the DB using sp_who2 or from sysprocesses

2. Execute dbcc outputbuffer(SPID)

From the output get the %completed status:

image

1 comment:

James Zicrov said...

I feel SQL server and other useful and necessary aspects help people to find more about something very useful.

SQL Server Load Soap API