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'
BACKUP DATABASE ProjectServer_Published TO DISK =
'\\SERVER\BackupSQL\ProjectServer_Published.BAK'
BACKUP DATABASE ProjectServer_Reporting TO DISK =
'\\SERVER\BackupSQL\ProjectServer_Reporting.BAK'
BACKUP DATABASE PWA_Content TO DISK =
'\\SERVER\BackupSQL\PWA_Content.BAK'
BACKUP DATABASE SharePoint_Config TO DISK =
'\\SERVER\BackupSQL\SharePoint_Config.BAK'
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