I am far from an expert. It has been a while since I set this up, but I=
did it with the help of IEA tech's.
That is something that they should be able to talk you through.
John
*********** REPLY SEPARATOR ***********
On 10/2/2000 at 11:29 AM keitenmiller@hughestech.net wrote:
>Thats a whole other story...
>Would you teach me how to make BackupNT work on our entire enterpize?
>Ken
>
>-----Original Message-----
>From: PowerNet [mailto:psc5@powersupply.net]
>Sent: Monday, October 02, 2000 11:15
>To: emerald@iea-software.com
>Subject: Re: [Emerald] Backup Database/Device with SQL 6.5
>
>
>One thing that may be happening that happened to us.
>When you create your backup routine, you need to make sure initialize=
device
>is checked. This will overwrite yesterdays info. Otherwise it will=
append
>every day and your disk will quickly fill up.
>
>We have a primary and backup database and run the following routines every
>night.
>
>Backup primary
>Transfer primary to backup
>Backup on the backup server
>
>Seems to work great for us.
>Our info on the backup is always a max of 24 hours old.
>
>John
>
>
>*********** REPLY SEPARATOR ***********
>
>On 10/2/2000 at 11:04 AM keitenmiller@hughestech.net wrote:
>
>>Back when we had Emerald originally set up, IEA created a backup device=
for
>>us.
>>At a later time I added it to the task scheduler.
>>A small problem showed up, It ate all of our disk space.
>>
>>Now I am trying to make this right... But what is the right way?
>>
>>Do I create a full database backup everyday?
>>Do I create a full database backup once a week with a log backup every=
day
>>in between?
>>
>>Using SQL 6.5 I have created a backup device called
>EmeraldDatabaseBackup...
>>I can make the damn thing make a full database backup everyday... but=
then
>>again, it will fill my drive quickly...
>>Is there a way to make it write over backups that are 7 days old?
>>OR
>>How do I need to set the whole thing up where it will make a full=
database
>>backup every Sunday, backup the log Monday thru Saturday, and the write
>over
>>the backups every third week(So I only have 2 weeks of backup stored on=
the
>>drive)?
>>
>>Any ideas, suggestions or help would be appreciated.
>>Thanks,
>>Ken Eitenmiller
>>Hughes Business Technologies
>>keitenmiller@hughestech.net
>>www.hughestech.net
>>
>>
>>
>>For more information about this list (including removal) go to:
>>http://www.iea-software.com/support/maillists/liststart
>
>
>
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart