Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rohans
Posting Yak Master
194 Posts |
 Posted - 2004-06-01 : 12:02:40
|
| I have scheduled backups running on my servers. However I notice one fo them doing a backup I did not request. From the logs this is what I get2004-05-31 22:08:49.12 backup Database backed up with following information: Database: DB_NAME, creation date and time: 2002/02/23(10:40:51), pages dumped: 34297, first LSN: 14627:1987:1, last LSN: 14627:1989:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'DB_NAME_00__cd0666a7_aabf_11d8_9f0b_000a5e03105b_'}).My back up goes to disk and I have never used a virtual device when doing backups, not even sure what kinda device it is refering to. I need help on this one.I also wantto know what does LSN mean?All help appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-01 : 13:10:56
|
| You should run a trace in SQL Profiler to determine what is doing this.LSNs are used to keep track of what is contained in the backup. They are used at the time of restore to determine what needs to be applied.Tara |
 |
|
|
|
|
|
backup on virtual device