Viewing 15 posts - 5,266 through 5,280 (of 6,676 total)
I put system databases in their own plan - perform integrity checks every night, backup all system databases (this includes model) and remove old backups older than 1 day (we...
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
April 24, 2009 at 10:06 am
GilaMonster (4/24/2009)It'll prevent page locks, but it means that if SQL decides to escalate locks, it will escalate to table level.
Gail - yeah, I probably should have mentioned that -...
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
April 24, 2009 at 9:59 am
Do you have a value that is the same in both databases that you could use to join? If so, you can use a merge join. Read up...
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
April 24, 2009 at 9:57 am
Are you backing up to a device - or a file? How is this being selected?
What Gail was trying to get at is that overwriting an existing file destroys...
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
April 24, 2009 at 9:55 am
What are you doing now to show the results view? If you write a query in a query window, you can select the columns you want to show and...
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
April 24, 2009 at 9:49 am
The only thing I know of is enabling/disabling the following:
ALLOW_ROW_LOCKS
ALLOW_PAGE_LOCKS
By default, the above options are ON for the indexes. You could try disabling (OFF) the option to ALLOW_PAGE_LOCKS 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
April 24, 2009 at 9:38 am
sharanurampur (4/24/2009)
I too don't know the exact problem, what I am predicting is we are having 2 instances and...
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
April 24, 2009 at 9:20 am
I am not sure - I do know that performing the shrink will force the pages to be re-allocated so there is free space at the end, which is going...
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
April 24, 2009 at 9:17 am
Bob Hovious (4/23/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
April 23, 2009 at 7:51 pm
Gift Peddie (4/23/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
April 23, 2009 at 5:35 pm
Because you are not using SQL Server 2008 Express - you do not have the option of attaching a user defined database. You have a server running that controls...
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
April 23, 2009 at 5:02 pm
What account is running SQL Agent? Does that account have the necessary rights to login to the other systems with Windows Authentication?
Are you sure the job running as an...
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
April 23, 2009 at 4:15 pm
Steve Jones - Editor (4/23/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
April 23, 2009 at 3:06 pm
If you decide to go with a table - then using a 3 character mnemonic as the key value would be my approach. That way, you have the mnemonic...
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
April 23, 2009 at 2:23 pm
According to this document http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx - I don't see where you cannot do any of the things you are trying to do.
I have used all of those items in 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
April 23, 2009 at 2:04 pm
Viewing 15 posts - 5,266 through 5,280 (of 6,676 total)