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

I am not really a DB guy. We don't have any back up servers for our DataBase. There is a need for some kind of back up service which can take production back up daily once in the morning and once in the evening .

Any suggestions ?

share|improve this question
add comment

migrated from stackoverflow.com Dec 10 '09 at 19:39

This question came from our site for professional and enthusiast programmers.

2 Answers

up vote 1 down vote accepted

If you just need basic backups they can be setup pretty easily from the maintenance plan interface.

http://msdn.microsoft.com/en-us/library/ms187658%28SQL.90%29.aspx

This link is more "wizardy"

http://msdn.microsoft.com/en-us/library/ms189036%28SQL.90%29.aspx

share|improve this answer
    
thanks that is all i needed –  Ved Dec 9 '09 at 20:42
    
that doesnt work for SQLExpress editions, by the way. only for full server editions. –  djangofan Dec 10 '09 at 21:06
add comment

I use redgates SQL Backup, it's worked for years very reliably, easy to set up, and it does streaming compression, so your backups don't take too much disk space.

share|improve this answer
add comment

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.