Viewing 15 posts - 5,026 through 5,040 (of 6,676 total)
Randy (6/12/2009)
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
June 12, 2009 at 4:21 pm
BTW - if you do not specify file locations in your create database statement, the default location defined for that instance will be used.
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
June 12, 2009 at 4:01 pm
Grant Fritchey (6/11/2009)
I'd suggest getting the DBCC run first. If there are problems with the database, you want to know prior to running...
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
June 11, 2009 at 1:41 pm
Ken (6/10/2009)
I took a second look at the query and I am not adding (or finding the min, max, avg, etc...) anything.
So, feeling...
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
June 10, 2009 at 1:45 pm
aa2home (6/10/2009)
I realy have problem with DB
Evrething is wrong .... database was not in full recovery model and backup is old
Any way
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
June 10, 2009 at 10:33 am
Can you post the query that is causing the problem? I would bet that it is because of the way the query is joined and/or how the query is...
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
June 9, 2009 at 5:16 pm
Not sure - because I am not sure what you have available.
Do you have a backup of the database?
Do you have a backup of the transaction log?
How old are 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
June 9, 2009 at 5:08 pm
Based upon what I have read here - my guess is that you rebuilt an index (or attempted to rebuild) that has not been previously selected. It now was...
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
June 9, 2009 at 5:00 pm
If the server (OS) already sees all 32GB of memory, and SQL Server is reporting 32GB of memory available then the PAE switch is enabled.
Now, all you have to do...
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
June 3, 2009 at 2:37 pm
mathieu_cupryk (6/3/2009)
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK...
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
June 3, 2009 at 2:14 pm
In the boot.ini file on the server - you have to have the /PAE switch set. I am going to guess that this is already the case because 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
June 3, 2009 at 1:40 pm
If you want to get help with your questions here, you really need to read the article I link to in my signature and post the create statements, sample data...
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
June 3, 2009 at 1:34 pm
Is AWE enabled - with the /PAE switch in the boot.ini also?
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
June 3, 2009 at 1:24 pm
mathieu_cupryk (6/3/2009)
I get an error of ticketID 0?
Sorry - no idea what that means.
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
June 3, 2009 at 1:22 pm
Because the transaction log needs 140MB at some point in time to handle the transactions that occur between your transaction log backups.
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
June 3, 2009 at 1:21 pm
Viewing 15 posts - 5,026 through 5,040 (of 6,676 total)