Can anyone help me with my MSSQL backup?

dwnthk · June 29, 2005, 8:23am

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?
?(

Stephen · June 29, 2005, 1:59pm

DTS can do it run the wizard and transfer it from our server to your local.

dwnthk · June 30, 2005, 3:10am

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 ?

Dwnthk

Stephen · June 30, 2005, 2:29pm

You can run a DTS wizard from Start, Run, Microsoft SQL Server, Import and Export Data.

dwnthk · July 4, 2005, 5:48am

But I want to schedule the process so that it will be done at midnight, you know what I mean, right!?

rmethod · July 4, 2005, 6:15pm

DTS jobs can be scheduled to run at anytime.

Richard M.

dwnthk · July 6, 2005, 2:28am

Thanks guys.

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

Thanks.

dave

rmethod · July 6, 2005, 2:51am

Look in the SQL Jobs tree node.

Richard M.