Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by (4MVP, Microsoft Partne)
  • When: 3 Apr 2012 2:45 AM
  • Last revision by (cMVP, Microsoft Community Contributo)
  • When: 18 Sep 2013 7:22 PM
  • Revisions: 9
  • Comments: 7
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  SharePoint 2010: SQL Script to Backup Project Server Databases

SharePoint 2010: SQL Script to Backup Project Server Databases

SharePoint 2010: SQL Script to Backup Project Server Databases

Backing up a Project Server database can be easier by using a procedure that includes all the database that you want to include. I drop that backup files on a share drive that is isolated from the server. 

Be sure the Share has write permissions for the SQL Process:
USE MASTER
BACKUP DATABASE ProjectServer_Archive TO DISK = '\\SERVER\BackupSQL\ProjectServer_Archive.BAK' WITH FORMAT
GO
 
BACKUP DATABASE ProjectServer_Draft TO DISK = '\\SERVER\BackupSQL\ProjectServer_Draft.BAK' WITH FORMAT
GO
BACKUP DATABASE ProjectServer_Published TO DISK = '\\SERVER\BackupSQL\ProjectServer_Published.BAK' WITH FORMAT
GO
BACKUP DATABASE ProjectServer_Reporting TO DISK = '\\SERVER\BackupSQL\ProjectServer_Reporting.BAK' WITH FORMAT
GO
BACKUP DATABASE PWA_Content TO DISK = '\\SERVER\BackupSQL\PWA_Content.BAK' WITH FORMAT
GO
 
BACKUP DATABASE SharePoint_Config TO DISK = '\\SERVER\BackupSQL\SharePoint_Config.BAK' WITH FORMAT
GO

For more information on Backup database in T-SQL: http://msdn.microsoft.com/en-us/library/ms186865(v=sql.105).aspx
, , , , , , , [Edit tags]
Leave a Comment
  • Please add 1 and 1 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 18 Sep 2013 7:22 PM

    Richard Mueller edited Revision 7. Comment: Change tag "SQL Server 2008R2" to "SQL Server 2008 R2"

  • 15 Aug 2013 3:23 AM

    Gokan Ozcifci edited Revision 6. Comment: Minor change

  • 30 Jul 2013 6:27 AM

    Gokan Ozcifci edited Revision 4. Comment: Content and tag

  • 27 Jul 2013 11:05 AM

    Patris_70 edited Revision 3. Comment: deleted (en-US) title

  • 9 Aug 2012 10:48 PM

    Amit Khare - Project Management Consultant edited Revision 2. Comment: tags update for project server 2007 , 2010, added url for t-SQl

  • 12 Apr 2012 6:02 AM

    Gokan Ozcifci edited Revision 1. Comment: edit content, new title and tags

  • 3 Apr 2012 10:30 AM

    Horizon_Net edited Original. Comment: added language tags

Page 1 of 1 (7 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 18 Sep 2013 7:22 PM

    Richard Mueller edited Revision 7. Comment: Change tag "SQL Server 2008R2" to "SQL Server 2008 R2"

  • Posted by
    on 15 Aug 2013 3:23 AM

    Gokan Ozcifci edited Revision 6. Comment: Minor change

  • Posted by
    on 30 Jul 2013 6:27 AM

    Gokan Ozcifci edited Revision 4. Comment: Content and tag

  • Posted by
    on 27 Jul 2013 11:05 AM

    Patris_70 edited Revision 3. Comment: deleted (en-US) title

  • Posted by
    on 9 Aug 2012 10:48 PM

    Amit Khare - Project Management Consultant edited Revision 2. Comment: tags update for project server 2007 , 2010, added url for t-SQl

  • Posted by
    on 12 Apr 2012 6:02 AM

    Gokan Ozcifci edited Revision 1. Comment: edit content, new title and tags

  • Posted by
    on 3 Apr 2012 10:30 AM

    Horizon_Net edited Original. Comment: added language tags

Page 1 of 1 (7 items)