db

i have to send a customer a copy of my database... anyone
know how to do that?
a copy of the database will be on his local pc where he
has installed sql server (no linked server please)!
thanxsYou can take a BACKUP of your database and ask the client to RESTORE the
same. Or, you can also DETACH the database and then ask the client to ATTACH
the database at another site. Check out the SQL Server BOL for more details.
All these tasks can be done either programmatically or manually using a tool
like Enterprise Manager.
--
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"css" <anonymous@.discussions.microsoft.com> wrote in message
news:06e501c3c614$bb30f7e0$a601280a@.phx.gbl...
> i have to send a customer a copy of my database... anyone
> know how to do that?
> a copy of the database will be on his local pc where he
> has installed sql server (no linked server please)!
> thanxs|||How about doing a BACKUP DATABASE and have your customer doing a RESTORE of that backup?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"css" <anonymous@.discussions.microsoft.com> wrote in message
news:06e501c3c614$bb30f7e0$a601280a@.phx.gbl...
> i have to send a customer a copy of my database... anyone
> know how to do that?
> a copy of the database will be on his local pc where he
> has installed sql server (no linked server please)!
> thanxs|||Attach/Detach will be faster than backup restore, but requires that the
original database be unavailable for several minutes while the files copy...
--
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
I support the Professional Association for SQL Server
(www.sqlpass.org)
"css" <anonymous@.discussions.microsoft.com> wrote in message
news:06e501c3c614$bb30f7e0$a601280a@.phx.gbl...
> i have to send a customer a copy of my database... anyone
> know how to do that?
> a copy of the database will be on his local pc where he
> has installed sql server (no linked server please)!
> thanxs