If at first you don’t succeed; call it version 1.0

Project Server 2003 was not designed to run on SQL 2005 but there is a way around this. Finding out how to do this was not easy hence why I have posted it here .

What to Do

1. Go to the install CD and copy the ‘D:\Support\Database‘ directory onto your computer.

Read more

To restore a SQL database, use the following syntax:

RESTORE DATABASE name
FROM DISK='c:\name.bak'
WITH MOVE 'name'
TO 'c:\Program Files\Microsoft SQL Server\MSSQL.1\Data\name.mdf',
MOVE 'name_log'
TO 'c:\Program Files\Microsoft SQL Server\MSSQL.1\Data\name_log.ldf'

Happy restoring