Database Backup

[Ken]

What are your suggestion in backing up a SQL 2000 DB. This will have to be done once per night.

[bruce]

We back up customer's SQL database on a daily basis.

If you want a backup file yourself, you should try schedule a DTS package (on your local SQL box) to pull the database from our server.

Hope this helps.

[b]quote:Originally posted by Ken

What are your suggestion in backing up a SQL 2000 DB. This will have to be done once per night.
</blockquote id="quote"></font id="quote">

[mikemc]

Bruce,

Do you maintain rotating copies of the backup i.e. do you write over the previous day's back up or not?

Senior Developer/Partner
aZ Software Developers

[bruce]

I believed it is rotated 7 days.

If you want to know the exact schedule, create a support ticket.


[b]quote:Originally posted by mikemc

Bruce,

Do you maintain rotating copies of the backup i.e. do you write over the previous day's back up or not?

Senior Developer/Partner
aZ Software Developers
</blockquote id="quote"></font id="quote">

[HogCall]

[b]quote:Originally posted by bruce

If you want to know the exact schedule, create a support ticket.
</blockquote id="quote"></font id="quote">

If someone creates a support ticket, can they please post the answer so that we all don't create support tickets?