0

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"

2 Answers 2

6

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.

0

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.

1
  • MS SQL Server, im using the developer version i think. Feb 12, 2011 at 23:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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