Any script to find out the percentage completion status of backup, restore or any other jobs running in SQL Server 2000?

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Paul White SSC Guru Points: 150468 More actions · Answer 1

Backup and restore both populate the percent_complete column on sys.dm_exec_requests.

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 2

SSC-Dedicated

Points: 33518

April 11, 2010 at 8:55 am

Is that available in SQL Server 2000?

Thanks.

Paul White SSC Guru Points: 150468 More actions · Answer 3

Sourav-657741 (4/11/2010)
Is that available in SQL Server 2000?

No.

chanti2985 SSC-Addicted Points: 429 More actions · Answer 4

SSC-Addicted

Points: 429

April 12, 2010 at 3:13 am

Dmvs are introduced in sql server 2005

Paul White SSC Guru Points: 150468 More actions · Answer 5

chanti2985 (4/12/2010)
Dmvs are introduced in sql server 2005

Yup.