Perry Whittle (5/14/2010)

---

use the following to ascertain backup sets that have been initaited against the database. Check the output to see if there are any unexpected\manual backups outside of the...

There was a maintenance plan doing full backups, which I disabled since the 14/5, that when I changed my recovery mode from Simple to full. and then I created new...

I am confused don't know what is the problem. I am doing some restore tests in a testing environment. so I had the following backup files:

1. Full on the 17/5...

Steve Jones - Editor (5/18/2010)

---

Are you a 8 hour a day company? Does business get done all day/night long? Those are good sized dbs, but not huge.

Also, is that data...

one is about 300 mb and the other one is about 500 mb . the second one is growing at a faster rate. in terms of local space it is...

Thanks Guys. i think the problem was another maintenance plan running and doing full backups at a different time, so that makes the differential backup part of a different set.

is...

oops looks like I posted the same thing twice, sorry about thta:-)

Full Backup script

BACKUP DATABASE [tass] TO DISK = N'F:\Test\tass_backup_201005140844.bak' WITH NOFORMAT, NOINIT, NAME = N'tass_backup_20100514084448', SKIP, REWIND, NOUNLOAD, STATS = 10

GO

declare @backupSetId as int

select @backupSetId = position...

here is the cript of the backup jobs:

Full Backup script

BACKUP DATABASE [tass] TO DISK = N'F:\Test\tass_backup_201005140844.bak' WITH NOFORMAT, NOINIT, NAME = N'tass_backup_20100514084448', SKIP, REWIND, NOUNLOAD, STATS =...

Dear All:

the response for my post was overwhelming. I would like to thank all the good people for their advise. thank you for the guidance and the inspiration.

your words...

Option one is far simpler and uses less resources, but you could only restore to 7pm the previous evening.

Thanks james for the prompt response. I am for the first option,...