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:
Adding fuel to my passion on SQL Server
1 comment:
I feel SQL server and other useful and necessary aspects help people to find more about something very useful.
SQL Server Load Soap API
Post a Comment