SQL Backup

Auto backup configuration in SQL2005

How to setup an autobackup for the backup type of Full database and transaction log together as a single bakup file in sql2005.? We can setup to backup full database seperately and transaction log seperately, but i wanted these two should be a single backup file. Any suggestion pls. ...

Full vs Transaction Log Backups

Is it nessisary to perform a log backup on a database that is set to Full recovery if I am uninterested in doing a point in time restore? I could opt for Simple, but, really my question is, why? My question also goes on to the size of the ldf file, and will it reuse space and not have to grow...

hourly backup schedule

have a question about client schedule settings. My problem is that I am using TDP for MS SQL and i want to backup database logs every hour but only during productive hours, e.g. from 6am til 5pm. The only way I solved is to create each schedule for each hour, because if i set parametres "period"...

SQL Studio Express scheduled backup

I need a scheduled backup for a standalone SQL database on an XP Pro PC. I have Studio Express installed and this does not have a scheduling utility. Can anyone suggest a way of achieving this without the expense of an SQL Express license