Thanks guys..

I'm working on everything you wrote...

but

quick question, using the script you guys have written, I keep adding on to the existing bak file (on K:\)...which I don't want.

how...

USE MASTER

BACKUP DATABASE [MSPHXX]

TO DISK = N'K:\MSPHXX_ARC.bak'

WITH NOFORMAT, NOINIT, NAME = N'MSPHXX_ARC',

SKIP, NOREWIND, NOUNLOAD, STATS = 10

GO

declare @sql varchar(max)

SELECT @sql = 'RESTORE DATABASE [MSPHXX_ARC'...

USE MASTER

BACKUP DATABASE [MSPHXX]

TO DISK = N'K:\MSPHXX_ARC.bak'

WITH NOFORMAT, NOINIT, NAME = N'MSPHXX_ARC',

SKIP, NOREWIND, NOUNLOAD, STATS = 10

GO

declare @ sql varchar(max)

SELECT @ sql = 'RESTORE...

Having trouble posing the script....crazy...

I can post anything that isn't code?

I tried using the IFCode shortcuts...doesn't help.

Here's what I ran:

As an overview - I need to create a BAK file of the existing MSPHXX. Then, restore that onto my K and L voumes (DB & log)...

I ran the script, with the move part added (thanks lowell,& steve)

But it didn't create my new end of month DB that I need.

Guessing there's a 'create DB' missing...

Lowell,

I'm testing what you wrote..but have a quick question:

How do i tell the restore script to use different volumes to restore on to?

Looking at your script it doesn't tell the...

Thanks for the reply.

I realize I'll need to make a custum job, but how do I have the job create a unique end of the month name for the DB...

Okay thanks for the advise everyone...

I'm going to create a test DB and start creating snapshots. Guess that's the only way I can really tell how big my snapshots will...

OKay I'm a little confused...

I thought the snapshots where very small in size...only containing 'changed data'

Awesome thanks !

Lynn Pettis (12/16/2009)

---

You need to use dynamic SQL. You can do it directly in the T-SQL job step or as a stored proc executed in a T-SQL job step....

I think the retension policy is going to be one year.

I don't really have access to the individual transactions. I know that sounds odd, but this is a core system for us, they do not want it tampered with directly....

No Jeff,

The balance data is updated throughout the day and is a rolling balance.

Do I don't really have a way..