Search:
Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in Replication

Interview Question :: SQL Backups run forever

I need some help with SQL backups - the databases can grow by over 5Gb a day with all the transaction logs and this is making the backup huge and the time window massive ! Last nights backup was 96Gb and took just over 14 hours ! There has to be a better way of doing this ! Can I use incremental with SQL databases ? Is replication better than tape backup ??? Any help greatly appreciated !

Thanks

Garry

Answers to "SQL Backups run forever "

RE: SQL Backups run forever ?
You must shutdown the databases before you commence a backup of an SQL database. If it is still open then the backup will run as long as the database is open. You can use something like Legato to perform sequential backups, which is what many commercial companies use. The price of hard drives has fallen and it is a much faster medium to backup to than DLT tape or any other tape.
Vote for this answer ::

RE: SQL Backups run forever ?
Have you set your database to automatically compact on close?
Vote for this answer ::

Notify me whenever an answer is posted for this question Update Alert Setting

Top Tags

- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers

Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in Replication

Interview Question :: SQL Backups run forever

Top Tags