river1 (4/29/2010)

---

Hi,

I need to know some information about backups.


1) in SQL Server 2005 where is the table that as the information about all the backups that where made to databases?


2) If i make a backup of one database in query window , like:

backup database test to disk ='c:\example.BAK'

will this backup be stored in that table (point 1)?


3) All the backups made to system databases (master, model, etc...) are stored in that table too?



4) Suppose that i have a database named test1 and i make two backups from query window, then i restore one of the backups that i made. The first Test1 database will be replaced by the backup of the test1 backup information. will the two backups made to the first test1 database will still be in the table of backups? or because the database was restored the backups associated with it will be deleted?


Thank you

river1 (4/29/2010)

---

Point 1:

"msdb..backupset (msdb..backupfile also has lot's of backup info)"

Didn't understood... what's the correct table to query and see the backups?


Thnak you

river1 (4/29/2010)

---

point 4:


So , if i have a database named test1 and make three backups and then restore one of the backups, those three backups will still be in that table, because they where made in that SQL Server 2005 instance.


You can only delete the historyc if you restore the msdb will and older backup or if you directly delete records from this table, correct?


Thank you.

river1 (4/29/2010)

---

Point 1:

It seems that this table backupset only contains information of the backups that where made to backup devices. At the company we make backups to file. when i make a backup like:

backup database sgt to disk ='c:\example.BAK' the name column of the table appears as NULL , why?