Back SQL SERVER 2000 thru VB 6`

[manuadoor]

How to backup Sql server 2000 MDF as well as LDF file from VB6.0. I expect a query for that since it is the only way to copy the said files with out stopping sql server service.

[szlamany]

Welcome to the forum!

There are many threads that talk about this - search for BACKUP FUNDS and you will find dozens.

I just did that and copy/pasted this post from another thread...

This thread has some great info:

http://www.vbforums.com/showthread.p...t=backup+funds

Basically, this is the T-SQL BACKUP command syntax:

BACKUP DATABASE Funds 
   TO DISK = 'c:\Funds_copy.bak'

The above thread talks about putting that into a STORED PROCEDURE and have the destination be a variable.

You can also setup regular backup's through ENTERPRISE MANAGER under the DATABASE MAINTENANCE PLAN wizard.

The perfect thing about a BACKUP is that it can be done with users in the database and it properly handles taking the DATA and LOG portions in a fashion that allows proper RESTORE

[manuadoor]

Dear friend,, I think u didn't get my question... I have seen many posts regardin this..


I want to copy the "MDF" as well as "LDF" files with out shutting down the sql server.. and not the .bak file....


Hope u can help me... thanks in advance

[szlamany]

Dear friend,, I think u didn't get my question... I have seen many posts regardin this..


I want to copy the "MDF" as well as "LDF" files with out shutting down the sql server.. and not the .bak file....


Hope u can help me... thanks in advance

You cannot copy the MDF and LDF files without shutting down the server or detaching the database.

SQL server has these files open with data streams being manipulated at all times between them.

Why do you want to do something like this???