Nater (9/19/2012)
Alright I got a few more questions. How exactly do backups work in SQL Server 2008.
Are you talking native backups or 3rd party (Litespeed, Sqlbackup, etc)?
Nater (9/19/2012)
Whats the need to seperate them onto their own drives?
The write I\O incurred during full backups especially can be high. You should be looking to separate all the individual SQL Server I\O channels (Log, Data, Tempdb, Backup).
Nater (9/19/2012)
Do SQL backups only run at a certain time of the day or do they actively run all the time?
They only run when you execute them via a script or maintenance plan.
Nater (9/19/2012)
Reason I ask is that our Database for the most part isnt going to be that large and our database is really going to sit doing nothing after work hours. Since the database isn't that huge I can't image that it will take that long and therefore would run after work hours. Would that be an issue?
Smaller databases would generally produce smaller backup files, but there caveats to this 😉
For instance transaction logs that have grown to 100 times the size of the primary data file would produce a large t-log backup!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉