Wednesday 20 April 2011

ASE : When was last full backup of database done?

dbcc traceon(3604)
dbcc dbtable("db_name")

"dbcc dbtale" prints the dbtable structure for a database and the last backup date for this dtable structure.

Look for "dbt_backup_start" in the output

No comments:

Post a Comment