IIRC (It's been a while), you need to schedule the snapshot AND schedule the subscription pull... 2 separate jobs.

Sounds like you already have a trace running that's outputting to your desired filename.

What are the results of: select * from sys.traces

IMO = In My Opinion

Others:

IIRC = If I recall Correctly

OP = Original Poster

FWIW = For What It's Worth

AFAIK = As far As I Know

etc...

http://www.gaarde.org/acronyms/

1) Restore most recent FULL Backup

2) Restore most recent DIFF newer than the FULL

3) Restore T-Logs newer than the DIFF

use STOPAT if you need to restore to a specific time

Restores...

I'm not clear what your question is. Please be more specific.

What is your backup stragety (frequency & types of backups)

Is that your restore plan ? If so, you don't...

Where is the changeable data coming from ? How is it determined ?

Not private. Sorry for the confusion. But some people need encouragement to put in some effort finding answers rather than just...

He wasn't asking you 😉

There are a lot of areas that affect performance: SQL database, db server, application server, network ....

That's going to vary a lot depending upon each person's environment. If this is homework or job interview, do some research.

If you have a specific question, then it is...

yes

.

.

.

New homework assignment ?

This thread deals with scripting database objects, and I run an automated process to dump them to files on a network share ... not quite sure what the OP...

GilaMonster (12/3/2010)

---

I don't recall having written an article on Trace. Grant wrote one that was published earlier this week and should still be on the front page. Make sure you've...

If you do a search of existing threads on this topic, you'll find that 99% of the time you should not be shrinking files because it hurts performance by fragmenting,...

30 hours seems a very long time for a backup !! Using BackupExec to tape, our 1 Tb database takes 6 hours. My 180 Gig backup takes...