March 15, 2004 at 4:41 am
guys,
i'm in need of a help from u.
i had to backup all the transactions done in my database daily and send a mail to my office from the factory. i'm using sql server 2000 in my machine. is there any way to save my data to a file daily and send thru mail. shd i need to write any procedure or is there any tool to do this process.
plz help me.
March 15, 2004 at 8:18 am
First, you say you are backing up the transaction logs and sending them.
Did you ever do a FULL backup and send that? You CAN NOT restore transaction logs without first restoring a full backup.
Next, I don't know how big your database is or how big it will get, but how are you mailing it (email or 'snail' mail)?
I would use the SQL Server BACKUP DATABASE and BACKUP LOG commands. Make backups to your hard drive and then from there do what you need to get them to you other office.
Refer to the BOL for the BACKUP DATABASE and BACKUP LOG command syntax.
-SQLBill
BOL=Books OnLine = Ms SQL Server Help
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply