I'm trying...unfortunately i'm just the administrator and the DBA set the job up so let me see what I can get from them

DavidB (12/4/2008)

---

Matt,

Sorry for the late reply to this (don't get to check the site very often, a bit busy) but something else to consider is that your transaction log...

george sibbald (12/4/2008)

---

snapshot replication could work for you, but would be more complex to set up and maintain then the good old backup and restore.

replication is really for scale out,...

i was just beginning to look through the replication idea...this does sound promising, but I can't find any good webpages describing the right setup....

hah, I suppose that would help!

alrightie...so backup/zip/copy/restore would be the option if they need to update...

thanks guys

But didn't a previous poster say that I'd need to have the remote database in a constant receiving state?

Anythign else besides compressing the backup and sending over the wire? I think that might be where i'm stuck..its about a 16GB database

Table: 'AllDocStreams' (1993058136); index ID: 1, database ID: 7

TABLE level scan performed.

- Pages Scanned................................: 2862

- Extents Scanned..............................: 380

- Extent Switches..............................: 2470

- Avg. Pages per Extent........................: 7.5

- Scan Density [Best Count:Actual...

hmmm thanks for the replies so far....

i guess this will be harder than I thought

i'm sorry to sound dumb...I administrate my companies sql but typically there isn't much needed to be done, can you tell me that more in basic admin terms 🙂

yea this was one of those dumb moments..I forgot that yesterday the Maintenance plan didn't work before I changed the account to be a domain account..it works now..thanks all

sql 2000, sp4 ....

I couldnt' get my maintenance plan to let me backup to a network drive

yes, looks great, but now i'm getting web.config errors from the application....dang lol

any idea of a forum for that?