Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Need help getting BE8.6SBS to backup open SQL database. 1
- Thread starter lbretth
- Start date
-
1
- #2
Don't do it!
You can buy the SQL agent which will do it, but as you'll see if you search this forum, there is a much better way to do it.
Use SQL Server wizards to dump the database to disk on the same server. Then you can backup a glorified text file straight to tape. It is much faster and less prone to failure. Also, a minor database error can be restored from disk not tape so that end is faster too.
Much neater solution.
You can buy the SQL agent which will do it, but as you'll see if you search this forum, there is a much better way to do it.
Use SQL Server wizards to dump the database to disk on the same server. Then you can backup a glorified text file straight to tape. It is much faster and less prone to failure. Also, a minor database error can be restored from disk not tape so that end is faster too.
Much neater solution.
- Status
Similar threads
- Locked
- Question