SQL 7 Migration

Site sponsored by:

The gold standard of SQL Server performance monitoring & diagnostics

RSS Feeds

SQL Server Performance » SQL Server 7.0 and 2000 Forum Topics » General DBA Questions » SQL 7 Migration

Last post 12-02-2008 4:15 AM by sramesh. 2 replies.

Page 1 of 1 (3 items)
Active Topics My Discussions Unanswered	Sort Posts: Previous Next

11-18-2008 6:10 AM

sramesh
Joined on 02-06-2006
Tamil Nadu India
Posts 259

SQL 7 Migration

Reply Contact

Hi all,

I have planned to move all databases from serverA to ServerB. Both servers are production server with same collation and same SQL Version.

ServerA and ServerB: SQL Server 7 Enteprise Edition

Memory:3.6 GB

Currently A have 116 GB db's, and B has 100 GB. I need to analyse load test for ServerB whether it is able to balance new databases or not.

Please tell me how to analyse this?

Thanks
S. Ramesh

11-26-2008 3:44 PM In reply to

satya
Joined on 11-05-2002
United Kingdom
Posts 22,747

Re: SQL 7 Migration

Reply Contact

http://support.microsoft.com/kb/224071

http://support.microsoft.com/kb/314546

http://vyaskn.tripod.com/moving_sql_server.htm

Those 3 should get you the information reqired.

-Satya S K J

SQL Server MVP

Knowledge is Power, you will gain by sharing it. SSQA.net - Invisible contributions to the users & visible success in SQL Community.

12-02-2008 4:15 AM In reply to

sramesh
Joined on 02-06-2006
Tamil Nadu India
Posts 259

Re: SQL 7 Migration

Reply Contact

Hi Sathya,

Thanks for the links, but I am looking for load test. Before move to another one database server, i need to verify whether the serverB able to performe good or not. I want avoid performance degreadation after dbs are moved to another server.

Thanks
S. Ramesh

Page 1 of 1 (3 items)

Active Topics My Discussions Unanswered Posts