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 ?
|
feedback
|
migrated from stackoverflow.com Dec 10 '09 at 19:39
This question came from our site for professional and enthusiast programmers.
|
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 | |||||
feedback
|
|
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. | |||
|
feedback
|
