Question on SQL Server 2008

07/18/2020 14:57 Exner.#1
when i added database SRO_VT_SHARD clean vsro ver 188 with sql 2008


[Only registered and activated users can see links. Click Here To Register...]

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
07/20/2020 08:57 Exner.#2
up
07/20/2020 18:38 NorseGodTyr#3
you can select any of the backup scroll right and you see the date [Backup date]
07/20/2020 23:11 FoxRayz#4
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.
07/21/2020 13:41 Exner.#5
Quote:
Originally Posted by FoxRayz View Post
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!

Quote:
Originally Posted by NorseGodTyr View Post
you can select any of the backup scroll right and you see the date [Backup date]
i select last backup this is good
07/23/2020 08:46 FoxRayz#6
Quote:
Originally Posted by Exner. View Post
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.