SQL Server 2012 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

SQL Server 2012

Author

Topic

rajbuneri
Starting Member

4 Posts

Posted - 2012-08-08 : 10:55:04

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.

Thank You

Raj Malook

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-08-08 : 11:07:11

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/

rajbuneri
Starting Member

4 Posts

Posted - 2012-08-08 : 15:34:23

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/

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-08-08 : 15:41:43

have you redefined the DNS for new instance db? did you try test connection?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources