Options
backup SQL database
mcse_696
Member Posts: 151
hi guy
Our company has SQL server 2005 Database , I need to do backup unfortunatly I m not familiar with SQL database , we have Acronis True Image Echo Enterprise Server I installed on lab environment , however I thing I need agent for SQL server to backup SQL database ,
help guysssssssssss
Our company has SQL server 2005 Database , I need to do backup unfortunatly I m not familiar with SQL database , we have Acronis True Image Echo Enterprise Server I installed on lab environment , however I thing I need agent for SQL server to backup SQL database ,
help guysssssssssss
Comments
-
Options
RobertKaucher
Member Posts: 4,299 ■■■■■■■■■■
Check out the section titled "Creating a SQL Server 2005 Maintenance Plan" in this article:
Creating Backup Jobs in SQL Server 2005
SQL Server does a very good job of backing itself up. I have it backup to a file share on my backup server. But I also do it to tape via an agent. But using the maintenance plans I am able to perform a full backup at night, transaction log backups every few hours, and a differential at about noon. -
OptionsTechJunky
Member Posts: 881
With SQL 2005 it makes it super simple. Backup and maintanace using SQL 2000 used to be a pain, have to use DTSRun to encrypt your jobs, multiple steps to index, etc for maintanance plans. SQL 2005 now has a wizard thats pretty much idiot proof.