Resources For IT Professionals
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

Revision #3

Wiki  >  TechNet Articles  >  SharePoint 2010: SQL Script to Backup Project Server Databases  >  Revision #3
SharePoint 2010: SQL Script to Backup Project Server Databases
You are currently reviewing an older revision of this page.
Go to current version
Backing up Project Server database can be easier by using a procedure that includes all the database that you want to include. I drop thet 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

Revert to this revision