automatice databackup in sql server 2005
Database
3
Posts
3
Posters
0
Views
1
Watching
-
how to set automatice data backup in sql server 2005
-
how to set automatice data backup in sql server 2005
Setting up a Maintenance Plan to backup databases: http://technet.microsoft.com/en-us/sqlserver/dd430301.aspx[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
how to set automatice data backup in sql server 2005
You could always setup a SQL Job to run:
BACKUP DATABASE MyDB TO DISK = N'G:\SQLBackup\MyDB_Backup.bak'
WITH INIT, NAME = N'MyDB Backup', SKIP, NOFORMAT, COMPRESSION