Hi There,

So I scripted the backup and it seems to work. I tried to use the restore as recommended but I'm having some issues.

What am I missing here?

USE SIS;

GO

BACKUP...

ok. thanks very much for the answer.

i'll give it a try and let you know how it all goes.

sean

Hi There,

when I run

select name, recovery_model_desc from sys.databases

I get

SISFULL

Hi There,

For the recovery model. Given that i'm no sql server guru. Recovery

page verify - checksum.

How can I back up everything logs, database from a procedure? Do you have any...

Hi Guys,

Thanks for the responses.I think the Peso's answer is a little more what I need. As there is only one month of data at a time I'm only interested...

HI There,

Sorry about the low brow post it's been a long week. I have attached some sample data and table structures. Basically what i'm trying to do is return a...

Thanks very much Jacob!

Hi There,

It seems to be working I will need to play around with it I guess. Can I ask one more question?

1. How can I store this in a variable...

HI All,

Thanks for all the opinions and answers. I think that I might have it now. If I have any dramas I will start a new thread.

thanks again,

Sean