Is it adequate to use the Database Copy Wizard for large databases.
The database is about 20 GB

Personally I would use BACKUP/RESTORE

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"GMG" <nospam (AT) nospam (DOT) com> wrote

Me too, even in that size I would rather trust on my own mistake rather than
of those from the wizard ;-)

--
HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> schrieb im Newsbeitrag
news:eUO1PpXbFHA.720 (AT) TK2MSFTNGP15 (DOT) phx.gbl...

- I'm a beginner ... How would you use backup/restore between a server on a
laptop and a desktop.

I tried the wizard and keep getting a "not trusted" error.
I tried your suggestion for backup and restore and cannot restore from any
other drive than the local drive that I saved it to.

"Allan Mitchell" wrote:

Hi,

Pleaser refer the Knowledge Base article below

INF: Using the WITH MOVE Option with the RESTORE Statement
http://support.microsoft.com/kb/221465

HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/kb/314546



Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.