Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2011-03-13
9
Medium Priority
?
1,039 Views
Last Modified: 2012-05-11
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
Comment
Question by:PDSWSS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
9 Comments
 
LVL 12

Expert Comment

by:NormanMaina
ID: 35122328
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
 

Author Comment

by:PDSWSS
ID: 35122842
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
 
LVL 10

Expert Comment

by:ImaCircularSaw
ID: 35125666
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
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 

Author Comment

by:PDSWSS
ID: 35128469
"that can be run using a scheduled task."   How would this be done?  Thanks
0
 
LVL 10

Accepted Solution

by:
ImaCircularSaw earned 2000 total points
ID: 35136315

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
 

Author Comment

by:PDSWSS
ID: 35139715
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
 
LVL 10

Assisted Solution

by:ImaCircularSaw
ImaCircularSaw earned 2000 total points
ID: 35139850
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
 

Author Comment

by:PDSWSS
ID: 35148532
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
 

Author Closing Comment

by:PDSWSS
ID: 35148542
Thanks
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question