presumably you are refferring to VMWare Server 2, there is a vast difference between ESX server and Vmware Server

Salma

you may want to include brackets around the database name too like so

backup database [Update_Master_Khasm] to disk = '\\10.1.5.250\Khasm\igmastback'

Ok, now i'm a little worried :unsure:

right click the database and check the options on the database properties dialog...

Grant who??

after the upgrade from sql2000 to sql2005 did you run the DBCC Updateusage and rebuild indexes?

you havent tried very hard then have you!

either the...

webqatesting (4/3/2009)

---

Hi

I have an application with SQL Server 2005 as the database.

Recently i'm getting an error " transaction log of the [mydatabase] is full ".

I searched for this error and...

what is the OS version/edition you are using?

once you start the restore process if you then kill it you have to wait for it to roll back, this could take some time, hence why it still shows...

in future, for sql2000 queries please post in the correct forum area 😉

it should live in the following location

C:\Program Files\Microsoft SQL Server\90\DTS\Binn

it should look like the file attached. Once you have changed this file you will need to restart the “SQL Server...

Achtang (4/2/2009)

---

That was good work even I was rolling my sleves up to do the same in sometime as I am at work cant imagine corrupting anything?

Thanks for that,...

Achtang (4/2/2009)

---

and also how do you apply hotfixes? I mean do you have to install it the same way as a SQL Server service pack? I mean do you have...

sorry matey, as the old saying goes "all pirates should find their own treasure", i cant be seen to be helping someone who condones piracy

it did work.

i restored master onto another instance called the db "Newone" and it created the files

newone.mdf

newone_1.ldf

i then detached the db after restoring it and copied the disk files to...