Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

2 Answers 2

up vote 6 down vote accepted

In the first instance use what SQL Server provides - http://technet.microsoft.com/en-us/library/ms187658.aspx

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

 
discard

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.