How to move Project Server 2007 databases to new partition on sameserver?

[greg]

When I initially installed PS2007 around a year ago I either skipped
or didn't see any option to choose the partition that the databases
will be stored on so they apparently defaulted to C:. The C:
partition is now full so I need to move all the databases to the D: on
the same server. Can someone point me to some directions on how to do
this?

Thanks,
Greg

 

[James Fraser]

When I initially installed PS2007 around a year ago I either skipped
or didn't see any option to choose the partition that the databases
will be stored on so they apparently defaulted to C:. The C:
partition is now full so I need to move all the databases to the D: on
the same server. Can someone point me to some directions on how to do
this?

Thanks,
Greg

If your server is using using a full version of SQL, then this is not
difficult at all. On the other hand, I'm not sure how to do this with
SQL Express that is installed when Project Server is installed in
"Stand Alone" mode. Searching on "Moving database files SQL Express"
should yield the answer.


Let us know more about your installation and then we can help you
further...
James Fraser

 

[greg]

If your server is using using a full version of SQL, then this is not
difficult at all. On the other hand, I'm not sure how to do this with
SQL Express that is installed when Project Server is installed in
"Stand Alone" mode. Searching on "Moving database files SQL Express"
should yield the answer.

Let us know more about your installation and then we can help you
further...
James Fraser

I'm using SQL2005 Standard Edition on Win2003 Enterprise.
Now that I think of it is this simply a matter of detaching, copying
the .mdf/.ldf from C: to D: then reattaching? Is Project Server/WSS
3.0 only concerned with the database server name and not the
partition?

Thanks,
Greg

 

[Wharton Computer Consulting]

I would do the following
1) Stop all sharepoint and project services
2) Deattch the Project Databases
3) Copy database to D drive
4) reattach project database on D drive
5) restart all sharePoint and project services

 

[James Fraser]

I'm using SQL2005 Standard Edition on Win2003 Enterprise.
Now that I think of it is this simply a matter of detaching, copying
the .mdf/.ldf from C: to D: then reattaching? Is Project Server/WSS
3.0 only concerned with the database server name and not the
partition?

Thanks,
Greg

Like Michael said, yes, the application server only cares about the
database server name and the database names. This should be the case
for any decent SQL based application. The application should not need
to worry about where the database resides on the DB server. It only
needs to talk to the SQL server to get the data, and the SQL server is
responsible for the dirty work of getting it to the disk.


James Fraser

 

[PedroJose]

Will there be any issues with Service packs/patches installations after
moving the databases??? would we need to move all DBs or just the bigger
ones (i.e. draft, published, wss content,....)

Please advise.

Thanks.