Saving backups of projects

[WSH]

hello,

This question has kind of already been answered but I'm still unsure of how
to do it.

I have many projects stored on the server. How do I save a back up of it? I
know its something to do with the built in sql. Can someone please give a
step by step guide of how to save it. I know it might sound obvious to a lot
of ppl but I really don't know how?!

Thanksx

 

[Rolly Perreaux]

hello,

This question has kind of already been answered but I'm still unsure of how
to do it.

I have many projects stored on the server. How do I save a back up of it? I
know its something to do with the built in sql. Can someone please give a
step by step guide of how to save it. I know it might sound obvious to a lot
of ppl but I really don't know how?!

Thanksx

1. Open SQL Server Enterprise Manager.
2. Navigate to the Database folder.
3. Right click on ProjectServer , select All Tasks --> Backup Database.
4. In the SQL Server Backup window, Name the Backup, then select
Database - complete, in the Destination section, click Add.
5. In the Select Backup Destination window, select File name and type
the path for the file name and click OK.
For example d:\backups\projbackup.bak
6. In the SQL Server Backup window, click the Options tab.
7. Select Verify backup upon completion and click OK.

Good Luck

--
Rolly Perreaux, PMP
Project Server Trainer/Consultant

IT Summit Series
Advanced Microsoft Technology Training
http://www.itsummitseries.com

 

[Rolly Perreaux]

hello,

This question has kind of already been answered but I'm still unsure of how
to do it.

I have many projects stored on the server. How do I save a back up of it? I
know its something to do with the built in sql. Can someone please give a
step by step guide of how to save it. I know it might sound obvious to a lot
of ppl but I really don't know how?!

Thanksx

Further...

If you need to backup a single project, there isn't a tool that can do
this automatically. However, all you would need to do is:

1. Launch Project Pro and log into Project Server
2. Open the project that you want to backup
3. From the Menu Bar, click File --> Save As --> Save As File
4. Save the project as an .mpp file

Good Luck

--
Rolly Perreaux, PMP
Project Server Trainer/Consultant

IT Summit Series
Advanced Microsoft Technology Training
http://www.itsummitseries.com

 

[WSH]

Rolly,

Thanks for the replies. I'm a bit stuck on something. Sounds a bit stupid
but where is the SQL Server Enterprise Manager? Maybe its just not been
installed on my PC?

 

[Rolly Perreaux]

Rolly,

Thanks for the replies. I'm a bit stuck on something. Sounds a bit stupid
but where is the SQL Server Enterprise Manager? Maybe its just not been
installed on my PC?

The SQL Server Enterprise Manager is located on the SQL Server. However,
you can install the SQL client tools from the SQL Server 2000 CD

Here's how you'd do it:

1. Insert your SQL Server 2000 CD.
2. At the Autorun menu, click on SQL Server 2000 Components.
3. At the Install Components menu, click Install Database Server.
4. At the SQL Server 2000 SP and below window, click Continue.
5. At the Welcome window, click Next
6. At the Computer Name window, accept default Local Computer and click
Next.
7. At the Installation Selection window, select Create a new instance of
SQL Server, or install Client Tools and click Next.
8. At the User Information, fill in the text boxes and click Next.
9. At the Software License Agreement window, click Yes.
10. At the Installation Definition window, select Client Tools Only and
click Next.
11. In the Select Components window, ensure that Management Tools -->
Enterprise Manager and Client Connectivity is selected, and click Next.
You can select additional optional components and sub-components if you
wish.
12. At the Start Copying Files window, click Next.
13. At the Setup Complete window, click Finish.

Make sure you install the latest SQL Server 2000 Service Pack
http://www.microsoft.com/sql/downloads/2000/sp4.mspx

Then you're done!

Good Luck

--
Rolly Perreaux, PMP
Project Server Trainer/Consultant

IT Summit Series
Advanced Microsoft Technology Training
http://www.itsummitseries.com

 

[Rolly Perreaux]

Rolly,

Thanks for the replies. I'm a bit stuck on something. Sounds a bit stupid
but where is the SQL Server Enterprise Manager? Maybe its just not been
installed on my PC?

Further...

I forgot the procedure to add the SQL Server to the Enterprise Manager
from your workstation after you installed the SQL Client Tools.
Here's how you do that:

1. Click on Start --> Programs --> Microsoft SQL Server --> Enterprise
Manager.
2. At the SQL Server Enterprise Manager console, navigate to and right
click SQL Server Group and select New SQL Server Registration.
3. In the Register SQL Server Wizard window, click Next.
4. In the Select a SQL Server window, under available server, select the
SQL Server you want to manage and include in the Enterprise Manager and
click Next. (This assumes that the SQL Server in joined to the Windows
Domain and is not stand-alone)
5. In the Select an Authentication Mode window, select The Windows
account information... and click Next.
Please note that your windows account will need to be added to the Local
Administrators group on the SQL Server.
6. In the Select SQL Server Group window, accept the default and click
Next.
7. In the Completing the Register SQL Server Wizard window, click
Finish.
8. The Register SQL Server Messages window appears,
a. if you have a login error under status, click Properties and in
the Registered SQL Server Properties window, click OK and then
click Close.
b. if not, click Close

Then you should have full access to the SQL Server Enterprise Manager to
do your backups.

Good Luck!

--
Rolly Perreaux, PMP
Project Server Trainer/Consultant

IT Summit Series
Advanced Microsoft Technology Training
http://www.itsummitseries.com