This is a memory issue. We'll either re-seat the memory or replace it.

Thank you.

That's it - thank you! And yes the transaction log backup is scheduled so it will come around. Good information. Thanks again.

Thank you for responding.

The vlf with status 2 is towards the end of the loginfo answerset. You can shrink an ldf up until that point - correct? For...

It's resolved. The issue was getting .NET Framework 3.5 on the server. We had issues doing that, finally got it done. Problem was 3.5 had to be...

Both jobs ran successfully last night.

Still baffled by what happened here. Error logs had no information about a failure. Job logs showed a failure but without explanation. ...

That's good information - and I am going to look into it..

Can you answer my questions regarding the following:

1. The original tempdb.mdf was 40 GB, with this script I would...

Thanks Gail,

I've read about the 'myth', and the increments suggested. We'll try it.

We also had discussions about where to place the data files, each on separate phyical drives...

Sorry for the slow response. We have a physical connection to them. No VPN or Internet and no trusted domain. That said we are going to create...

Thanks Grant - appreciate the comments.

Grant,

Thanks for responding. You kind of hit the nail right on the head in that these databases are being moved from SQL 2000 and 2005 to SQL 2008. ...

This looks good. Thank you for helping!!

I tried running the script in SQL 2000.

copied part of the script running a simple "SELECT * FROM sys.server_principals ;"

Msg 208, Level 16, State 1, Line 1

Invalid object...

It took some review but got it to work. Your suggestion about modifying type to Operating System did help. It was also required modifying the sqlcmd input (final...

I created a new task, creating everything from scratch again (script, task arguments, everything). Backup ran successfully. No rhyme or reason as to what happened. Hiccup in...

Ran a query against the database using that script:

BACKUP DATABASE [Resource] TO DISK = N'D:\SQL_Database_Backup\Resource_noinit.bak'

It ran successfully, the bak was created. Any ideas?