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.
Printable View
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.
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:
The above thread talks about putting that into a STORED PROCEDURE and have the destination be a variable.Code:BACKUP DATABASE Funds
TO DISK = 'c:\Funds_copy.bak'
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
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.Quote:
Originally Posted by manuadoor
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???