Back up History of a DB
Select backup_set_id, backup_finish_date, name from
msdb..backupset where database_name = N'myDataBase'
and type = 'D' order by backup_start_date desc
Talks on SQL Server, database development, data management techniques,SQLBI/SSIS/SSAS/SSRS etc. Want to publish something db related ? mail to bineeshthomas@gmail.com with subject line starting as "SQLNET"
SQL NET FORUMPortal Maintained By : BINEESH THOMAS
0 Comments:
Post a Comment
Links to this post:
Create a Link
<< Home