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

No comments: