Post reply

Database Migration Project - More Questions

  • October 19, 2004 at 9:22 am

    #86818

    I think I may use the Import/Export Wizard to do my Database Migration Project. I feel more comfortable with it.

    I have a few more questions:

    1) When moving a DB with the Backup/Restore Method, do you still have to create the Logins, Users, Roles, DTS Packages, Jobs, Operators and Alerts separately?

    2) When backing up a 40 GB Database, do you have any idea how long it takes (to disk? then to tape?)? Our bandwidth is 100 Mb.

    3) Does the Backup Feature allow you to backup a SQL Database from one server to a .bak disk file on another server on the same network? Would I have to use the UNC Naming Standard?

    4) When using the detach/attach stored procedures and coping the mdf and ldf files to the new server, do you still have to create the Logins, Users, Roles, DTS Packages, Jobs, Operators and Alerts separately?

    5) When using the Import/Export Wizard is it best to transfer the Server Logins within the wizard or use the DTS Transfer Logins Task to transfer the logins in a separate step before using the Import/Export Wizard to transfer the Databases?

    6) Is the orphaned users problem that results from migrating Databases only with Standard Logons?

    Thanks a bunch.

  • October 19, 2004 at 9:41 am

    #527205

    1) When moving a DB with the Backup/Restore Method, do you still have to create the Logins, Users, Roles, DTS Packages, Jobs, Operators and Alerts separately?

    >> All depends on how are you going to setup the server. This is the one of the links that you might want to take a look at it.

    http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224071

     

    2) When backing up a 40 GB Database, do you have any idea how long it takes (to disk? then to tape?)? Our bandwidth is 100 Mb.

    >> All depends on your network storage assume that you are storing on network storage. I am getting 6MB/sec for backup 3.5MB/sec for restore.

    3) Does the Backup Feature allow you to backup a SQL Database from one server to a .bak disk file on another server on the same network?

    >> YES

    Would I have to use the UNC Naming Standard?

    >> YES but you can also map the drive but I'd recommend to use UNC name.

    4) When using the detach/attach stored procedures and coping the mdf and ldf files to the new server, do you still have to create the Logins, Users, Roles, DTS Packages, Jobs, Operators and Alerts separately?

    >> See above links

    5) When using the Import/Export Wizard is it best to transfer the Server Logins within the wizard or use the DTS Transfer Logins Task to transfer the logins in a separate step before using the Import/Export Wizard to transfer the Databases?

    >> I'd do that.

    6) Is the orphaned users problem that results from migrating Databases only with Standard Logons?

    >> See these links

    274188 PRB: "Troubleshooting orphaned uusers" topic in Books Online is incomplete
    246133 How to transfer logins and passwords between instances of SQL Server
    168001 PRB: User logon and/or permission errors after restoring dump
     
    Good luck!

Viewing 2 posts - 1 through 1 (of 1 total)

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