Dumping sql server

21 Apr 2007 4:59 PM

John

Hi

Is there a way to dump all the sql server data into some sort of file that
can be imported into a local sql server later? I have used sql server dumper
but it is not very stable and crashes during sump.

Thanks

Regards

21 Apr 2007 6:50 PM

Kalen Delaney

Hi John

This has already been answered in both the .server and the .newuser
newsgroups.

--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com

Show quote

"John" <John@nospam.infovis.co.uk> wrote in message
news:uiXLeZDhHHA.4596@TK2MSFTNGP05.phx.gbl...
> Hi
>
> Is there a way to dump all the sql server data into some sort of file that
> can be imported into a local sql server later? I have used sql server
> dumper
> but it is not very stable and crashes during sump.
>
> Thanks
>
> Regards
>
>
>