I detach database from one instance and then attched to another instance in another server,On both the server running same instances names and other specifications but when i want to acces the newly attched database it fails, so anyone can guide me that what is the problum and what will be the solution. I think this is the logins problumes i transfered the logins but no use. I am new to the SQL server administration.Thanks
Or Guide me How to take complete database from one instance to another instance in another server.
Thanks for your reply and the DB is attached sucessfully,And DB is available in the Oject Expl,All the tables with data are available but when i am trying to connect the clients it show, Error 87,40,1826 something like that. I try to make ODBC connection from client side through the System DNS, But fails.
Thank You Regards
quote:Originally posted by visakh16
whats the error you're getting? was the db attach process succesful? can you see db in object explorer beneath the server in ssms?
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
SQL Server 2012
Posted - 08/08/2012 : 10:55:04
