SQL Server 2005 backup files

Posted on 2008-01-29
Medium Priority
Last Modified: 2011-04-14
Are the backup files that can be found in the folder C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup sufficient in term of an actually database backup? What I mean is, will I be able to recover from these files if something happened? Or should I be using some other method of backing up my databases?

Question by:coanda
  • 2

Expert Comment

ID: 20772318
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup is only a default backup folder for your SQL Server instance. But you still need to make regular backups  to be able to recover any database. It does not happen automatically unles someone (mayby you) defined maintenance plans which place backup files into your folder. Check the dates of backup files - if they are quite old, dont rely on them.

Author Comment

ID: 20772491
Forgive my ignorance when it comes to MS SQL Server, I'm a bit of a noob on the topic, but does it have a built in utility for performing backup/restore or would I go through the Windows backup wizard?

Accepted Solution

maradam earned 600 total points
ID: 20772621
Yes, you have a built in utility called Maintenance Plans. In SSMS expand your server->Management->Maintenance Plans->right click->New maintenance plan. Name your plan and then drag and drop Back Up Database Task from the toolbox and then configure it. Its rather strightforward, but you must still do this if you need up to date backups.

Assisted Solution

avbsql earned 400 total points
ID: 20772637
U can use the backup wizard provided with SQL 2005 management studio. Let me know if you need step by step details. Open Mnagement studio>expand Database folder> select the database and right click to backup the database providing the details required. These are backup's saved on disk. In case of issues with your hard disk u might lose data that's on disk. Few options are to back it up to tape or another to another server at a different location. It all depends what is available for you budget. Get give you more details fi you want on backup's/options available.

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question