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:09:07
|
| 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 .. |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-03-06 : 07:36:46
|
| How are you trying to restore it?Are you set up with correct permissions on both machines?-------Moo. :) |
 |
|
|
shanmugaraj
Posting Yak Master
219 Posts |
Posted - 2006-03-06 : 23:45:57
|
| yes mr_mist. even i tried to paste the ldf , mdf files but in vain. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-03-07 : 00:01:19
|
| You should read what this is saying:"You must be logged in as 'sa', or a member of sysadmin, or a member of dbcreator to perform this operation."Seems fairly clear: Either login with the SA login, or some other login the is in either the server sysadmin or dbcreator role before you attempt to run the restore.If you don't know what this means, you should read about it in SQL Server Books Online.CODO ERGO SUM |
|
|
|
|
|
|
HOW TO COPY DATABASE & PASTE IN NEW M/c