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
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Error message when copying database

Author  Topic 

satya068
Posting Yak Master

233 Posts

Posted - 2010-03-22 : 10:01:04
hi..

When i am trying to copy the hole database from MRT_FIN sql_server1 to sql_server2

there is an error mesage

'THE SHARE NAME HAS TO BE SPECIFIED FOR DATABASE MRT_FIN'

1)Do i need to create an empty database before coppying into the new sql_server2?

could any one help me in this query!

thanks
)

yashu

namman
Constraint Violating Yak Guru

285 Posts

Posted - 2010-03-23 : 13:37:35

1)Do i need to create an empty database before coppying into the new sql_server2?


No, it is created during the process.

Do you copy by using script or MSMS?
Go to Top of Page
   

- Advertisement -