Viewing 15 posts - 3,481 through 3,495 (of 6,676 total)
thang_ngo_2002 (12/9/2010)
So I think the temporary best way now is install SQL...
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
December 9, 2010 at 7:45 pm
GSquared (12/8/2010)
Absolutely.I was speaking (writing) in general terms. There are always valid exceptions.
I knew that 🙂
Now, if I could only convince the vendor that this job needs to be...
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
December 8, 2010 at 6:35 pm
GSquared (12/7/2010)
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
December 7, 2010 at 7:36 pm
Take a look at this article: http://www.mssqltips.com/tip.asp?tip=2167
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
December 6, 2010 at 3:02 pm
I would download and use a tool like WinDirStat to identify what files are using the space. Until you know what files are using the space - you really...
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
December 2, 2010 at 3:25 pm
The point is - everytime you restart the server, SQL Server starts without any data in the buffer cache and no plans cached. So, the first time data 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
November 30, 2010 at 7:45 pm
Lowell (11/30/2010)
if the server was beefy enough...
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
November 30, 2010 at 3:10 pm
You need to also realize that the developer edition is licensed by individual - not by server. So, if you install developer edition on a server and have 5...
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
November 30, 2010 at 1:43 pm
GSquared (11/30/2010)
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
November 30, 2010 at 1:36 pm
AlexSQLForums (11/29/2010)
I was able to recover needed data by creating a different db with same size and replacing the mdf file and than using emergency mode and 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
November 29, 2010 at 2:45 pm
You don't need to add local system to that right - it is part of the local administrators group already and has that right by default.
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
November 23, 2010 at 8:41 am
Check for any jobs setup to rebuild/reorganize your indexes - that is generally where someone will add code to truncate the log (e.g. BACKUP LOG ... WITH TRUNCATE_ONLY).
Also look for...
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
November 23, 2010 at 8:38 am
To maintain the ownership chain - you need to have those schemas owned by the same user. If both schemas are owned by dbo, you shouldn't have any problems...
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
November 23, 2010 at 8:32 am
If you are using a maintenance plan - which is an SSIS package, it is possible that it is running through integration services.
I think it depends on what version level...
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
November 22, 2010 at 1:08 pm
Whether or not you need 8 files - you should not set the auto-growth to a percentage. And, just because you have 2 TB of space available - does...
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
November 22, 2010 at 12:59 pm
Viewing 15 posts - 3,481 through 3,495 (of 6,676 total)