Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Im "new" to SQL Server and i want to start doing backups of all my data. Whats a good starting place? are there any good tools out there for this? Also i'd like it if i could have backups that could be potential loading into another instance of SQL Server on a separate Server incase our current one "dies"

share|improve this question
up vote 6 down vote accepted

In the first instance use what SQL Server provides -

Maintenance plans are the quickest and easiest way to backup your databases, and you can use the .bak files to populate another server.

If you're already running another backup system (Like Backup Exec) you could also investigate what addons they have for SQL Server.

share|improve this answer

I assume you mean MS SQL?

You could start with a SQL Agent job to dump the database to a file which can then be backed up. This can be a regular job.

If you're on SQL Express you can accomplish the same thing with a Windows scheduled task I think.

share|improve this answer
MS SQL Server, im using the developer version i think. – Letseatlunch Feb 12 '11 at 23:36

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.