Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 best backup solution

Author  Topic 

mrose1120
Starting Member

11 Posts

Posted - 2006-07-24 : 11:15:47
Hi all,
This is only my 2nd thread, but i've recently taken on administration of SQL and SQL admin at my company. Some of the backups are currently setup but I would like to make sure they are the best possible. Could someone point me in the direction or let me know a tutorial of the best practices if I want to backup my databases nightly and ensure I could restore fully? Thanks in advance.

mrose1120
Starting Member

11 Posts

Posted - 2006-07-24 : 11:23:56
also, I will be backing up the .bak file from the SQL Server after it is done using a Veritas remote agent, and would like to keep separate backups of each nght of the week.
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-07-24 : 11:28:29
You may find these useful.

FAQ - Frequently Given Answers
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210

Backup all databases in server
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62868

In need of maintenance plan
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=69490


CODO ERGO SUM
Go to Top of Page
   

- Advertisement -