Viewing 15 posts - 4,696 through 4,710 (of 6,676 total)
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2009 at 4:33 pm
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2009 at 4:28 pm
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2009 at 4:14 pm
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2009 at 4:11 pm
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2009 at 10:31 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....
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2009 at 10:25 am
Glad I could help 🙂
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2009 at 9:25 am
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 12, 2009 at 10:12 pm
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 12, 2009 at 10:19 am
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 12, 2009 at 9:45 am
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 12, 2009 at 9:36 am
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 12, 2009 at 9:06 am
If this is new drives - I would do the following:
1) Shut down all services (SQL Server, etc...), change to Manual startup type
2) Change drive letter on D: to X:...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 11, 2009 at 8:59 pm
Well, I am not sure that I would approach it that way. It all depends upon how you are going to get that new storage available. Is the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 11, 2009 at 8:33 pm
There are two options for the copy database wizard - which one are you selecting?
FWIW - I have found it to be a lot easier to just do a backup/restore...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 11, 2009 at 8:26 pm
Viewing 15 posts - 4,696 through 4,710 (of 6,676 total)