Post reply

Making a Dedicated SQL 2000 server

  • May 12, 2004 at 7:39 pm

    #107874

    Hi all

    My company have  a requirement to Create  a one dedicated sql server me being  the DBA.

    Its little bit complex as we run about 4 web based applications  and  3 other major applications where the sql is the dbase in backend.

    all db's around 85  and  over 345 tables in  5 servers installed time to time by diffrent programmers ..... (I dont know as i just started working with them )

    I need to know how I  transfer /copy all DB's to newly created one server?

    My plan is to  Restore one master db of one of the old servers which has 90 user logins

    restore other db's like msdb, temp .... user db's

    then start with second server  restore user db's and create user logins new ....

     

    can anyone suggest me a better way to do this  I really need to comine  5 sql 2000 servers in to one actually by dropping  60 % of  databases which is not using according to the company.

    Thanks in advance

    Singa

     

     

     

  • May 13, 2004 at 10:29 pm

    #506406

    Is the requirement to have all databases exist within a single SQL2000 instance, or can you merely move all five instances to a single machine?

    Ian Dundas
    Senior IT Analyst - Database
    Manitoba Public Insurance Corp.

  • May 13, 2004 at 11:23 pm

    #506411

    if you are creating a new SQL server and you are going to not use the 5 instances then the easist way to move DB's would be to dettach them from the 5 SQL server instants, move the DB's and logs to the new SQL server and then re-attach them. you do not need to keep a master file etc as the new master file when you attach the databases will pick up the old settings.

     

    Good luck 

  • May 14, 2004 at 2:16 am

    #506434

    Try using DTS ...

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply