Question on SQL Server 2008

[Exner.]

when i added database SRO_VT_SHARD clean vsro ver 188 with sql 2008




check photo to understand what i mean

Select the first,or second, or both

If someone tells me why appear 2x database SRO_VT_SHARD inside sql 2008 only

[Exner.]

up

[NorseGodTyr]

you can select any of the backup scroll right and you see the date [Backup date]

[FoxRayz]

This is two database backups. You can see the sequence number of which the latest one is. Its the last one in your grid so just check that one.

[Exner.]

Originally Posted by FoxRayz

This is two database backups. You can see the sequence number of which the latest one is. Its the last one in your grid so just check that one.

first backup
Checked SRO_VT_SHARD-Full Database Backup Database Full XRAY898\SQLEXPRESS SRO_VT_SHARD 1 22900000002405200134 22900000002410700001 22900000002405200134 22900000002405200134 9/23/2011 11:11:33 AM 9/23/2011 11:11:37 AM 74672640 XRAY898\Administrator

the second backup
Checked SRO_VT_SHARD-Full Database Backup Database Full XRAY898\SQLEXPRESS SRO_VT_SHARD 2 22795000000445400083 22795000000448900001 22795000000445400083 22795000000445400083 9/23/2011 1:39:09 PM 9/23/2011 1:39:12 PM 74146816 XRAY898\Administrator

I want to know what is appropriate the last or first!

Originally Posted by NorseGodTyr

you can select any of the backup scroll right and you see the date [Backup date]

i select last backup this is good

[FoxRayz]

Originally Posted by Exner.

first backup
Checked SRO_VT_SHARD-Full Database Backup Database Full XRAY898\SQLEXPRESS SRO_VT_SHARD 1 22900000002405200134 22900000002410700001 22900000002405200134 22900000002405200134 9/23/2011 11:11:33 AM 9/23/2011 11:11:37 AM 74672640 XRAY898\Administrator

the second backup
Checked SRO_VT_SHARD-Full Database Backup Database Full XRAY898\SQLEXPRESS SRO_VT_SHARD 2 22795000000445400083 22795000000448900001 22795000000445400083 22795000000445400083 9/23/2011 1:39:09 PM 9/23/2011 1:39:12 PM 74146816 XRAY898\Administrator

I want to know what is appropriate the last or first!



i select last backup this is good

The first one is the latest backup in your list here. It was the opposite way in your screenshot though. Look on the sequency number i have boldmarked for you. Higher number means newer backup.