Hello everyone,
I am using SQL Server 2008 Enterprise on Windows Server 2008 x64. I want to run daily job at mid-night every day to make full backup of database. Any reference document to follow for a newbie of this topic?
thanks in advance, George
+1
A:
You'll need to add a job to the SQL Server Agent, it's in your object explorer when you log on with MSSMS.
But I think it's better to ask this on serverfault.com
Gerrie Schenck
2009-12-22 08:11:56
I know how to add a job to SQL Server Agent, I want to know how to implement the job to do a full backup of database. Sorry, I am a newbie to do maintenance. :-)
George2
2009-12-22 08:17:37
What's the difference?
Gerrie Schenck
2009-12-22 08:20:35
I do not know how to write a job to do database backup, can you recommend me some samples please? I am previously working on ADO.Net programming, the DBA is OOF, and I am doing some maintenance job -- so I say I am a newbie of maintenance. :-)
George2
2009-12-22 08:25:48
Thanks, question answered!
George2
2009-12-22 08:57:49
+1
A:
Try running the Maintenance Plan wizard, to set up a nightly backup.
Later, read about backups in Books Online and Paul Randal's blog.
Rob Farley
2009-12-22 08:24:55