Viewing 15 posts - 30,181 through 30,195 (of 49,552 total)
That's what I expected.
The server you're connected to is SQL 2005, not SQL 2008. That's why you can't set compat level to 100, the highest possible is 90 for SQL...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2010 at 3:41 am
crazy4sql (10/6/2010)
If the log chain is broken after shrinking the log.
No it is not.
Have a look of
http://support.microsoft.com/kb/873235
saying
Important After you manually truncate the transaction log files, you must...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2010 at 3:37 am
crazy4sql (10/6/2010)
using SSMS-- right click on database--tasks--shrink--files--select the file type as log and shrink.
Won't help if the log is full.
Make sure you take the fresh full backup after this...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2010 at 3:19 am
Please run the following and post the results
SELECT @@version
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2010 at 3:09 am
Anyone interested in tackling the 'truncate table is not logged and cannot be rolled back' myth for this month's T-SQL tuesday?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2010 at 3:02 am
Please post table definitions, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2010 at 3:00 am
Take a look through this article - http://www.sqlservercentral.com/articles/64582/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2010 at 2:36 am
Please don't crosspost. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic998994-8-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2010 at 2:15 am
Gowtham Chowdary (10/6/2010)
1) how much perfomance gain i can get using simple recovery for distributor database.
Probably none. Recovery model does not have a big (if any) impact on performance.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2010 at 2:11 am
Looks like you just installed the client tools, not the database engine. Install the database engine (beware licensing) and SQLAgent will install with it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2010 at 12:06 am
bitbucket-25253 (10/5/2010)
Now how many members of the thread will be coming to SQL Saturday#60 in Cleveland......
24 hours of travel and just over $1500 air fare. Think I may pass this...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2010 at 12:04 am
Craig Farrell (10/5/2010)
The Dixie Flatline (10/5/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2010 at 12:04 am
Just to be safe, can you run CheckDB manually.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
SQL 2005 or SQL 2000?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 5, 2010 at 11:58 pm
Login trigger? If you want to monitor their logins not what they do afterwards. You can also prevent those logins with an appropriate login trigger.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 5, 2010 at 11:58 pm
Craig Farrell (10/5/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 5, 2010 at 11:56 pm
Viewing 15 posts - 30,181 through 30,195 (of 49,552 total)