Hi 
  I want to backup my SQL server database,but the operation doesn't run while 
my service manager is start ,when I stop that I can take a backup.
  I have used these commands to do that,I don't know how to use a sql command 
to backup.please guide me.
  //***********
  AdoConnection1.Connected:=False;
S:=ExtractFilePath(Application.ExeName)+'data\storage1_Data.mdf';
  Sourec1:=TfileStream.Create(S,FmOpenRead);
Dest1:=TFileStream.Create('c:\storage1_Data.mdf',FmCreate);
Try
comprStream1 := TCompressionStream.Create(clFastest, Dest1);
try
comprStream1.CopyFrom(Sourec1, Sourec1.Size);
comprStream1.CompressionRate;


                        
---------------------------------
Do you Yahoo!?
 Everyone is raving about the  all-new Yahoo! Mail Beta.

[Non-text portions of this message have been removed]



-----------------------------------------------------
Home page: http://groups.yahoo.com/group/delphi-en/
To unsubscribe: [EMAIL PROTECTED] 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/delphi-en/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 



Reply via email to