nigelc (8/13/2009)

---

That doesn't seem right as no one is working from 6pm onwards.

If i look at the log on the file server it is showing a size of 1.5gig...

The solution is rather simple - don't use backup devices. Change the plans to use a file and let SQL Server generate the file name. When you do...

htt (8/13/2009)

---

Lynn Pettis (8/13/2009)

---

htt (8/13/2009)

---

here is what I have done for years to my SQL 2000 and SQL 2005 databases: full bk nightly; log bk every 15 minutes from 5...

I have no idea what AQL is - so, I have to ask where you found the term? My WAG is that the original post you found it in...

I think I know what is going on here - but before I say anything on that, please confirm that you are in fact backing up to a device (single...

Did you enable AWE in SQL Server? You posted this in the SQL Server 7/2000 forum - are you running 2000 or 2005 and what Edition of SQL Server...

You're crazy :hehe:

Every transaction gets logged in the transaction log, regardless of the recovery model. The difference is just in the details of how the transactions are dealt with...

Is this a typo on your part, or did you cut & paste?

Under IP Address tab here are the settings:

IP1

Active: Yes

Enabled: Yes

IP Address: 192.1681.1.64

TCP Dynamic Ports:

TCP Port: 1433

I am...

It sounds like you are not performing any transaction log backups. If you were, then you wouldn't need a second log file, or be looking at creating a third....

Glad I could help 🙂

I am not sure about the problems you are having with the disks. I don't setup clusters since I am a DBA - but I do not know how...

Yeah, I know exactly how that goes - but there comes a point when you have spent as much time trying to fix the issue that you would have spent...

Not from what I have seen - this error is caused by some piece of a previous installation of SQL Server that is not fully uninstalled. By rebuilding your...

That's too bad - other links have shown other applications could be interfering also. I hope you can find the offending application(s) and remove them, otherwise you are looking...

That looks like a problem with MSXML - which has caused quite a few issues with SQL Server installs. I found this: http://www.avianwaves.com/Blog/default.aspx?id=98&t=Mystery-of-the-SQL-Server-2008-RTM-MsiGe - which walks through how to...