I don't know the answer myself, but have you looked at job adverts for that role as a starting point?

You probably don't have time right this second, but this book (SQL Server Backup & Restore)[/url] is very good, and the pdf version can be downloaded for free.

The reason people...

Oh yes, I see what you mean; I don't have one but I got the same message as you when I went to test it.

Any chance you've AdBlocked your own...

"What, my the Administrator?" 😉

I can see your avatar. Does that help? Probably not.

There's nothing else if you scroll up? Which command are you running?

Thanks. I'm feeling cautious so I thought I'd better double-check!

Ok, I changed it to + REPLACE(REPLACE(REPLACE(CONVERT(varchar,GETDATE(), 20),'-',''),':',''),' ','') + '. (also on that thread I linked to)

instead, and now it works :cool:. So I will have a series of...

Thanks- I did check that, sorry not to be clear!

Ok, when I comment out

+ replace(convert(nvarchar(50), getdate(), 120), ' ',':') + N'.trn'

it works. Huh?

... also the SQL Server Service Account is in the Administrators' group on the server.

Write your backup statement so that each time the backup runs it backs up to a new file, easiest way is to stamp the date and time into the file...

Brilliant, thank you. I must confess I woke up in the middle of the night and that exact thought popped into my brain. I'm just run so ragged at the...

When I run that I get 7 rows back. Is that the sort of thing you suspected?

Thanks

No WITH options currently.

Thanks.

BACKUP LOG 'databasename'

... and at 1 pm it was 31,795 KB - a fairly big jump, no?

Thanks for the reply. The log file is backed up every hour, and the database is...