Sorry Lynn but I can't post code...something wierd @ work stops me from posting code...tried everything

but if you look in this post..it's the restore part of the statement that...

When I run the restore part -

I get an error

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'MSPHXX_ARC'.

Msg 319, Level 15, State 1, Line 4

Incorrect syntax near the...

Lol..

Okay should have asked this but..

How do I create a 'delete' trigger that sends any delete transaction on my table to a different table?

Okay kinda figured...

Thanks Steve.

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 !