Let's start a very intresting thread here:
As you all know moving the database from one server(2000, 2005, 2008) to (2000, 20005, 20008) is not a big deal and can be done in many ways like backup-restore, attcah-detach, and most easy (some time very complex:-)).
Here i wanna discuss an issue which i have faced.
I have two instances of SQL server 2008, i have created a new database Test in one instance, created few logins and mapped to Test database with some permissions for this Test database.
Now i used copy database wizard to copy this test database to other instance, i sucessfully went through the wizard and selected SQL server object method to copy the Test database in other instance then i followed the remaing wizard, i selected the logins which i have created for the Test database and finnaly i reached the finish button i clicked finished and the copy of database completed sucessfully. I verified that Test dabase was there in other instance with the logins which i have created. So easy i was happy:-)
Problem: Some other day i wanted to copy AdventureWork database to the other instance of SQl server i was happy that its a very easy task i followed the same steps above(to copy the Test database ) and every thing went in the same way and i clicked finish to complete the wizard it took some time
View Complete Post