Skip to Content
0
Former Member
Jul 07, 2009 at 02:33 PM

Moving Database Server & Fixing Reports

32 Views

Hello.

We are planning on retiring our database server (Win2003/MS SQL2000) which holds the database for our Crystal Reports Server XI R2. Crystal is loaded on a different server, only the database is on the database server.

The two questions i have are as follows.

1. what is the best way to move the database to the new database server. The new server will be running Win2003 & MS SQL2000 like the old server. The only difference is that it is in a cluster, and a different server name.

2. the second question is what's the easiest way to change all reports including recurring schedules to point to the new database server.

any help would be greatly appreciated.