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.
| Author |
Topic |
|
shanmugaraj
Posting Yak Master
219 Posts |
 Posted - 2006-03-06 : 06:07:44
|
| Hi,HOW TO COPY DATABASE & PASTE IN NEW M/cI have a database on remote SQL SERVER M/cNow i want to copy the database from remote m/c to my local machine. I have SQL 2000 Desktop edition.I backup the datatbase from server and when i restore a database in local m/c, error msg comes ::TITILE : Microsoft SQL-DMO(ODBC SQL State:HY000)Location : upgraddb.cpp:214Expression : tableIndex <Array_len(upgradeMap)SPID: 7ProcessID:2400Error 22021:[SQL-DMO]You must be logged in as 'sa', or a member of sysadmin, or a member of dbcreator to perform this operation.weather i should install SQL desktop again with any special option or is there any way to copy a database from one m/c to other .Knidly help me .. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
copy database to other m/c