Got a script, to do this but not sure what i need to change to get it to work correctly

/*==================================================================================

NAME: ...

do you backup to tape once a week ?

if so why not set it to delete logs older than 1week. which probably wont save much on disk costs.

I have setup...

Hi ,

Are you talking about Enterprise manager I am using sql 2000 ent edition.

what gui tools are you talking about if not Ent manager,

and what tools does all your scripting...

I was thinking it could be something like that so just trying to restore only with the 11:00 to see if that was the problem,

Thanks for confirming the problem and...

Thank you.

Frank.

Great thanks for that.

got it working now,

Can someone explain a few commands to me, the following ones i don't understand or no my options.

WITH FILE =1 what does the with...

Thanks for the advice,

where would the with move command go in this script.

also do i need to restore the log file after doing a full back restore, i was thinking...

sorry here it is.

restore statement

ALTER DATABASE Changepoint SET SINGLE_USER WITH ROLLBACK IMMEDIATE

restore database Changepoint from disk = 'd:\temp\changepoint_diff1.bak' WITH RECOVERY

GO

ALTER DATABASE changepoint SET MULTI_USER

Error message

Nonqualified transactions are being...

Hi

Here is my script for backing up can anyone help me change it to do a restore please.

BACKUP DATABASE [Changepoint] TO DISK = N'd:\temp\changepoint_diff1.bak' WITH NOINIT , ...

Thanks Greg,

Our tape backups occur everyday, weekends full and weekdays incrementials.

I am still confused on how to write this, I have managed to setup a differential backup but can not...

Thanks I'l take a look at BOL.

also If I create the scripts and keep the naming the same of the differential backups the scripts never need to be changed unless...

Thanks John,

any chance you could show me an example script of what you have said,

also could I have to seperate jobs to do the diferentials and the full ?

Thanks alot...

Hi

Thanks Greg.

I guess if I wanted to schedule this as a job i would need to create it in the master database ?

this is what i have done so far...

Hi Greg.

do you know how I can include this in a script to check and lock user out for the restore to work successfuly and then allow the users to...

I'm new to all this, so just trying to learn all of this.

Thanks for the info guys thats great.

Frank