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
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
  • Richard Mueller edited Revision 7. Comment: Change tag "SQL Server 2008R2" to "SQL Server 2008 R2"

  • Gokan Ozcifci edited Revision 6. Comment: Minor change

  • Gokan Ozcifci edited Revision 4. Comment: Content and tag

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

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

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

  • 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
  • Richard Mueller edited Revision 7. Comment: Change tag "SQL Server 2008R2" to "SQL Server 2008 R2"

  • Gokan Ozcifci edited Revision 6. Comment: Minor change

  • Gokan Ozcifci edited Revision 4. Comment: Content and tag

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

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

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

  • Horizon_Net edited Original. Comment: added language tags

Page 1 of 1 (7 items)