We had two physical SQL servers and copying one database using the wizard to
the other sqlserver was easy because both services used the same domain
account. Now i will have to copy databases from one server to another
outside the domain. This means they will have seperate logins for the
sqlserver service. how can i then use the copy database wizard? It fails
because it can't create a file on the ditination server'
does this mean i have to use log shipping or use a script and then copy just
data'
thanks.You can use backup/restore or sp_attachdb, sp_detachdb. You will have to
manually script out the logins. See this page for more info:
http://support.microsoft.com/defaul...kb;en-us;246133
Ray Higdon MCSE, MCDBA, CCNA
--
"Richard K." <google@.walkersca.com> wrote in message
news:uCR%23ry98DHA.3404@.TK2MSFTNGP09.phx.gbl...
> We had two physical SQL servers and copying one database using the wizard
to
> the other sqlserver was easy because both services used the same domain
> account. Now i will have to copy databases from one server to another
> outside the domain. This means they will have seperate logins for the
> sqlserver service. how can i then use the copy database wizard? It fails
> because it can't create a file on the ditination server'
> does this mean i have to use log shipping or use a script and then copy
just
> data'
> thanks.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment