Best way to copy database

I set up a test SQL server that I want to be exactly like the live server.
The test server is only available over the internet connected via TCP with
no network sharing or anything like that. What is the best way to copy the
data [all databases, tables & stored procedures] from my live server to the
test server? I tried using the backup wizard but it gives me an error
saying can not create share. When I use the export data function I get
errors like user account does not exists and various other errors.
Can someone suggest the best way to do this?
Bill
You should be able to use DTS.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
|||When I use the Copy database wizard to create the DTS package I get an
error, "Failed to create the share OMWWIZC." I am trying to copy from a
server over the internet using TCP/IP with SQL login only. It sounds like
DTS would require windows authentication since it create shares. Is there
another way or am I wrong?
Thanks.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:opso2q8prxrj9kur@.hcottter-lap...
> You should be able to use DTS.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
|||don't use the copy database wizard, use export data (right click on your
database and select all tasks to find this). I believe this option does not
require a file share.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Bill" <msgdev@.hotmail.com> wrote in message
news:#kJDTcrPFHA.3292@.TK2MSFTNGP12.phx.gbl...
> When I use the Copy database wizard to create the DTS package I get an
> error, "Failed to create the share OMWWIZC." I am trying to copy from a
> server over the internet using TCP/IP with SQL login only. It sounds like
> DTS would require windows authentication since it create shares. Is there
> another way or am I wrong?
> Thanks.
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:opso2q8prxrj9kur@.hcottter-lap...
>
|||I managed to get most of the data over using export data but I am having a
problem with one database. It looks like there is a NT account added as a
login "<Domain>\Doman users." The error I get now is related to this user
not being on the new server. The servers are part of two different domains
so there is no way, that I know of, to add this user to the new server. I
am not the one who originally set up the server so I don't want to make any
changes to the live server if possible. Is there anyway to get around this
error?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uSRXjnrPFHA.3144@.tk2msftngp13.phx.gbl...
> don't use the copy database wizard, use export data (right click on your
> database and select all tasks to find this). I believe this option does
> not
> require a file share.
>
> --
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Bill" <msgdev@.hotmail.com> wrote in message
> news:#kJDTcrPFHA.3292@.TK2MSFTNGP12.phx.gbl...
>