Moving a Database to another Server

How can i move a Database from one to another 2 SQL Server 7.0 SP2
I already backed up the Database and restored it on the new Server but
now i have the Error Message that the role is alreasdy in the Database ,
but there are no user at all created.These should be helpful, especially the ones about Logins etc.
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"dibetage" <dibetage@.discussions.microsoft.com> wrote in message
news:4944B79D-CFA7-47C8-B53F-1781A4BA422F@.microsoft.com...
> How can i move a Database from one to another 2 SQL Server 7.0 SP2
> I already backed up the Database and restored it on the new Server but
> now i have the Error Message that the role is alreasdy in the Database ,
> but there are no user at all created.
>
>

MOVE physical data file to another foler?

Is there any way that I can MOVE databases physical files
to different folder in same server? I had a restored many
databases from another server using BackupExec but it
created a folder MSSQL7 which is come from original path.
Now, my new server with SQL2000 located at MSSQL\DATA and
after restored using backupexec it put them at MSSQL7
\DATA, I have two Data folders which we don't like it.
I tried to use Copy DB wizard but it won't let me copy in
same SQL instence.
Please let me know you have any suggestion on this.
Thanks
SunnySunny,
INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224071
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"lintadsl" <lintadsl@.yahoo.com> wrote in message
news:05b901c35ac8$e6ffd1f0$a101280a@.phx.gbl...
> Is there any way that I can MOVE databases physical files
> to different folder in same server? I had a restored many
> databases from another server using BackupExec but it
> created a folder MSSQL7 which is come from original path.
> Now, my new server with SQL2000 located at MSSQL\DATA and
> after restored using backupexec it put them at MSSQL7
> \DATA, I have two Data folders which we don't like it.
> I tried to use Copy DB wizard but it won't let me copy in
> same SQL instence.
> Please let me know you have any suggestion on this.
> Thanks
> Sunny|||Thank you for the link.
I will take a little more time before post a question here.
That link was big help! Actually it tells me what I need.
Have a nice day.
Sunny
>--Original Message--
>Sunny,
>INF: Moving SQL Server Databases to a New Location with
Detach/Attach
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q224071
>--
>Dinesh.
>SQL Server FAQ at
>http://www.tkdinesh.com
>"lintadsl" <lintadsl@.yahoo.com> wrote in message
>news:05b901c35ac8$e6ffd1f0$a101280a@.phx.gbl...
>> Is there any way that I can MOVE databases physical
files
>> to different folder in same server? I had a restored
many
>> databases from another server using BackupExec but it
>> created a folder MSSQL7 which is come from original
path.
>> Now, my new server with SQL2000 located at MSSQL\DATA
and
>> after restored using backupexec it put them at MSSQL7
>> \DATA, I have two Data folders which we don't like it.
>> I tried to use Copy DB wizard but it won't let me copy
in
>> same SQL instence.
>> Please let me know you have any suggestion on this.
>> Thanks
>> Sunny
>
>.
>