Copy a database

Hi,
I need to copy a database from sqlserver 2005 to another server sqlserver
2005 too.
I am administrador of the server source, and dbowner of a empty database
into the server destination.
Can someone help with this?
Thanks in advance
Hi,
If you use SQL Server logins, remember about this:
http://support.microsoft.com/kb/274188
Do you know how deal with domain users when restore database from DomainA
(logins from DomainA) to server in DomainB?
Regards,
anxcomp
|||I like back-up restore also but you can also dettach the database, copy the
files using your operating system and then attach the copied database to
your destination instance
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/
Atlanta's Business Intelligence and Data Warehouse Experts
"Vipper" <Vipper@.discussions.microsoft.com> wrote in message
news:0166FB25-A835-4901-A0D7-8CB509847B22@.microsoft.com...
> Hi,
> I need to copy a database from sqlserver 2005 to another server sqlserver
> 2005 too.
> I am administrador of the server source, and dbowner of a empty database
> into the server destination.
> Can someone help with this?
> Thanks in advance