hi,

I'll post an updated version of this script at the weekend.

Paul

the transactions are still written to the log in full, it's just truncated at the next checkpoint.

i'm sure sp_cycle_errorlog does not delete the archive files, it moves them along (errorlog becomes errorlog.1, errorlog.1 becomes errorlog.2 etc). the only one that is removed is errorlog.6. Sounds like...

xp_enumerrorlogs returns just the one row ? there should be a row for each errorlog file. Is the max number of errorlogs set to 1 somehow ?

(it's meant to be...

what does executing xp_enumerrorlogs in master return ?

Hi,

look at linked servers in BOL.

Paul

hi,

the script seems to have disappeared. I've re-added it, but it will be a few days until it's approved, So check back then.

Thanks

Paul

Hi,

that's exactly why i wrote it, people often forget to remove full recovery mode when they copy from a production environment, so it has caused me issues...

Thanks for the suggestions Luigi and Matteo. I'll make the suggested changes. I'll post it later in the week , as the scripts need to be checked by the administrators...

thanks kselich, I've never seen a database with a . in the name before, so I didn't consider that. I'll make the change on the script.

Paul

are you backing up to tape or disk ?

it could be parallel processing.

Paul

hi,

a comprehensive answer to the same question on your other post.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=394744

Paul

Ed,

thanks for that, I'll take a look

Paul

hi,

there is a free version of SQL 2005., called SQL Server 2005 express, it comes with Books Online and is a very good way to learn SQL 2005. have a...