SQL Server 2005 backup files

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?

Thanks.
LVL 3
coandaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

maradamCommented:
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.
0
coandaAuthor Commented:
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?
0
maradamCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
avbsqlCommented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage Software

From novice to tech pro — start learning today.