Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1060
  • Last Modified:

How would you schedule daily backups of the Sharepoint 2010 Content DB in SQL 2008 R2 Server Management Studio?

I use Maintenance Plans to run daily backups of SQL DBs. However, in the Sharepoint Instance in SQL SMS there is no option to use the Maintenance Wizard
to set up daily backups. In addition the SQL Server Agent is not visible.

In this case, how would you schedule daily back ups of the Sharepoint 2010 Content DB in SQL 2008 R2 Server Management Studio?
0
PDSWSS
Asked:
PDSWSS
  • 5
  • 3
2 Solutions
 
Norman MainaCommented:
Try this:
1.In the computer with the sharepoint database,go to services and start the sql agent instance.
2.In the computer with sql server management studio(standard or enterprise) -go to services and enable and start sql browser service.
3.in the computer with sql server manaagement studio - connect to the sharepoint instance and try to create a maintenance plan as usual.
0
 
PDSWSSAuthor Commented:
SQL Server Agent (SQL server) was started

SQL Server Agent (Sharepoint) -  When I start it - it immediately stops and gives the attached message

Please advise?

Started SQL Browser

Thanks
Picture-3.png
0
 
ImaCircularSawCommented:
I would recommend using STSADM/PowerShell in a batch file that can be run using a scheduled task.

On SP2007 I would use the following command:

STSADM -o backup -url http://<root site> -filament c:\backup.bak

You can then easily use:

STSADM -o restore -url http://<root site> -filament c:\backup.bak -overwrite

This is much easier to restore with.

There is probably a better PowerShell command for 2010 but can't research it right now.
0
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

 
PDSWSSAuthor Commented:
"that can be run using a scheduled task."   How would this be done?  Thanks
0
 
ImaCircularSawCommented:

1

Create a batch file with the command line code in it you want to run.

2

Click Start and type Task Scheduler.  You should find a link appear of the same name, click it.

3

In the actions pane click Create Task
You'll want to make sure the code you've written names files with the date they were created.  Also, you'll probably want to create a task that deletes off old backups.

The reason I use this form of backup/restore for SharePoint is that it's much easier to recover from than an SQL backup.  I would recommend you have SQL backups too as a layer of redundancy.
0
 
PDSWSSAuthor Commented:
How do you make sure the code you've written names files with the date they were created and deletes off old backups? Thanks
0
 
ImaCircularSawCommented:
http://www.speedguide.net/articles/how-to-backup-using-batch-files-1547

I think this link will help you answer that question.  I don't have any example code to hand.
0
 
PDSWSSAuthor Commented:
Thanks for your input. The code suggested in your link does not work for me for adding date and time.
I have created a new question to address that issue                                                                                  http://www.experts-exchange.com/Storage/Backup_Restore/Q_26890920.html

and will give the 500 points.  
0
 
PDSWSSAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now