Can anyone help me with my MSSQL backup?

D

dwnthk

Guppy
Hi guys,

I have a MSSQL. However, my backup device cannot backup a running sql server (or you have to pay for extra module)!

Can I do something like export the whole data source into a, let say, file, so I can schedule my backup device to back it up?

bcp or dtswiz can do it?
?(
 
Thanks.

I am absolutely new to mssql. Is dts a line command that I can just type in the c:\ ? Is it able to export the whole database (including storeprocs)? And How :p ?


Dwnthk
 
You can run a DTS wizard from Start, Run, Microsoft SQL Server, Import and Export Data.
 
But I want to schedule the process so that it will be done at midnight, you know what I mean, right!?
 
Thanks guys.

Is DTS a wizard of mssql? How can I call it (I can't find it in the sql admin)?

Thanks.

dave :D
 
You must log in or register to reply here.
Back
Top