Best way to back up SQL Server 2008 database?

54,915 pts.
Tags:
Shadow Copy
SQL Server 2008
SQL Server 2008 administration
Sql Server 2008 Backup
SQL Server database
What's the best way to back up my SQL Server 2008 database? We are currently backing up the SQL data files during off hours but soon we'll be going 24/7 and we'll need to use maintenance plans and shadow copy. Can someone provide help?

Software/Hardware used:
SQL Server 2008
ASKED: July 16, 2010  7:50 PM
UPDATED: July 16, 2010  8:32 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

First stop backing up the SQL data files. Unless you are shutting down the SQL Server first, you aren’t doing anything that is usable.

Use the BACKUP DATABASE command to backup the database to disk, then move that backup off to tape. If you need point in time recovery then put the database into full recovery mode, and schedule log backups via the BACKUP LOG command to run through out the day. The log should be backed up how ever often you need to in order to meet your recovery requirements. In other words, if you can only afford to loose 10 minutes of data, then you need to backup the log every 10 minutes.

Make sure that the backups are written to a disk other than the one that the SQL Server data files are on.

Shadow copies aren’t supported with SQL Server as SQL Server never releases the locks on the files.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • ITKE
    [...] 6. Have any follow-up help to Mr. Denny’s suggestion for the best way to back up a SQL Server 2008 database? [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following