Backup Automatic WSS_Content On Database SQL 2008 R2

Below are steps to backup wss_content sharepoint 2010 on sql 2008 :
1. Log on user administrator on sql
2. Start SQL Server Agent then click Job --> New Job

3. Specify name of job

4. Click Step then click New

5. Complete field on columb then click OK

6. Click Schedule then click New

7. Specify the job schedule then click OK

8. Click Notification then mark the check box
9. Click OK

10. Start Job on Step if you have run the job.

Note :

Database Script

 use WSS_Content_2012

       DECLARE @fileName VARCHAR(MAX)

       DECLARE @dbname VARCHAR(MAX)

       DECLARE @string_date VARCHAR(MAX)

      

       -- set nama database yang mau dibackup

       SET @dbname = 'WSS_Content_2012'

       -- set string

       SET @string_date = REPLACE(CAST(GETDATE() as varchar(max)),':','_')

       -- set filename

         SET @fileName = 'C:\Backup\wss_content2012_'+ @string_date+ '.BAK'

        

         -- SELECT @filename

       BACKUP DATABASE @dbname TO DISK = @fileName

• Specify a drive location--> C:\Backup\wss_content2012_
• according to the database used--> use WSS_Content_2012

Posted in: Server