Who could tell me how I can know when the specified database was backup and
how long I dnt backup my database and who does the backup?
Thanks
huiIf you simply need to know when the DB was last backup you can select
TaskPadview in EM. If you need a little more you can open a backup file
using RESTORE HEADERONLY.
M|||This information is available in the four backup history tables in the msdb
database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"hui" <gary1971_cn@.163.com> wrote in message news:uyvRKfJ1FHA.3300@.TK2MSFTNGP15.phx.gbl...[v
bcol=seagreen]
> Who could tell me how I can know when the specified database was backup an
d
> how long I dnt backup my database and who does the backup?
> Thanks
> hui
>[/vbcol]
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment