Steve, thanks for the feedback. I only asked because I had a prius as a loan car for a month, and I hated it, there was no sense of 'involvement'...

aaah....thats annoying................

Suresh is correct. 5Gb is not big so no need to start splitting out...

Steve, as someone who obviously likes cars, and even owns a 911 (and survived), do you actually enjoy driving the Prius?

Trader Sam (7/29/2008)

Yes, but where else in the world can...

if its a VLDB you can backup at the filegroup level.

I this ia for an exam question do yourself a favour and google filegroups, plus check out BOL and MSDN

got to agree it is worth keeping at least two backups on disk, especially as if you have to recover a database its always possible it is required to recover...

which reminds me, any columns SQL generates statistics on (_WA_sys*) are possibly candidates for indexes as the optimiser has obviously decided it needs info on those columns.

if you only want one day then yes make retemtion period 23 hours or less depending on how long backup takes. time recorded on .bak file is when it completes,...

IMHO

IP Addr ...

since you mention SQLAgent I dont think that should affect the group in the event of it stopping as SQLAgent is not critical to an app functioning so why have...

what Perry and Terry (great name for a double act) are saying is with 64 bit SQL you should set max memory of sql server to about 2Gb less than...

if you want to ascertain which backups have failed why are you querying the master database, surely you want to query msdb anyway. (you won't harm that either)

Also....could be useful to post your table definition.

Is the date column defined as a datetime and are you entering a time as well as a date, or just 00:00:00 for...

this date field would not be a good candidate for the clustered index, or any other index, because it is not very selective, with only 7 distinct dates each value...