SQL Server 2000 BACKup

[Sabin_33]

I'm using SQL Server 2000 and VB6.
I am only using Access and MSDE Query as my tools, I have nothing else :( .

I was curious about creating Backups and Restoring Data in SQL SERVER using SQL.

I've looked around but the topic is apparently real broad. Mostly everybody is using enterprise manager.

Any ideas?

[d-u]

You may want to look into this (http://www.vbforums.com/showthread.php?t=339970&highlight=sql+server+back-up)... BTW, it's for VB6.0...

[Sabin_33]

Thanks d-u. I found a lot of helpful information on that

[Sabin_33]

What about maintenace.

Anything in SQL without Enterprise manager I can do?

[exterminator]

You could look into the bulk copy utility with SQL server/Sybase - here - bcp (on msdn) (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_bcp_61et.asp). Hope this helps. Regards.

Go through these threads as well:
1. bcp command (http://www.codeguru.com/forum/showthread.php?t=358865&highlight=bcp)
2. SQL Server 2k Insert Trigger - Output to file (http://www.codeguru.com/forum/showthread.php?t=361921&highlight=bcp)