pleasure Ian, hope it works out.

Shame there wasn't more response, but you can never tell with a public forum what will elicit responses.

then unless you can contact someone who can help you and has access to that drive this sounds like an uninstall via add\remove programs and a reinstall. ensure when you...

backup to a file, not a device.

backing up the database will not shrink the tran log if that is what you are expecting, but at 160mb I would not call...

can you see the drive? do you have access to it, are the files there?

whats happened to this server recently? Has SQL ever started? Has someone tried to move the...

the error iscomplaining about running the backup in a transaction. How are you trying to backup the database?

post the code if you are doing it using T-SQL code.

the database files for the model and msdb database are not where SQL expects them to be. As model cannot be found, tempdb cannot be created (tempdb is created from...

select serverproperty('collation')

VM's? controversial. let us know how that pans out....

Steve Jones - Editor (12/18/2009)

---

Force, ha! I'm powerful in the ways of the word, or at least keyboard in this universe website.

Broken images came about as we upgraded servers yesterday....

Ian, I don't think they are looking for war and peace here.

I think you have answered your own question in the last paragraph - remaining in the technical sphere, advancing...

A simple sp_who2 will tell you if there is a restore running. In this case there will not be as you stopped the restore job. If you kill a restore...

http://msdn.microsoft.com/en-us/library/cc280361.aspx

persevere, you'll get used to it!

nothing running at all? Even just running reindex on the database will cause log file growth and if you have growth factor at default 10% its going to grow in...

then you should get improvement. Put debug statements in your code to see what is actually executed.