Moving SQL server 2005 Db

[AgentM]

Hi,
I need to move a SQL server 2005 database nearly 9 GB to another machine on a different domain.
What is the best way to do this ?

I tried taking a backup then do a restore on the new machine and it failed with an "Access denied error".

thanks for your help.

 

[mrdenny]

That would be the correct method. You'll need to copy the backup file to the new machine, then do the restore locally using an account which is a member of the sysadmin fixed server role.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog