Viewing 15 posts - 26,611 through 26,625 (of 49,552 total)
The database owner is invalid. Probably because it was an AD account that has since been removed from AD.
sp_changedbowner and change the owner to sa.
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
April 19, 2011 at 12:22 pm
jasonmorris (4/19/2011)
Starting to make a bit more sense but even with "set statistics time, io on" the output is identical.
I would expect that they would be. As Gus said, "All...
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
April 19, 2011 at 12:17 pm
Those are Client Stats. What Jack's asking for is the output when STATISTICS IO is on.
SET STATISTICS IO ON
GO
<run query>
Also note that costs are estimates, not necessarily accurate values
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
April 19, 2011 at 8:45 am
Check that the log backups are succeeding.
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
April 19, 2011 at 8:43 am
Have a read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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
April 19, 2011 at 7:51 am
HowardW (4/19/2011)
Joseph Fallon (4/19/2011)
There is another DBA - I'm going to get my big stick and go a-hunting.
Happy hunting 😀
I can recommend Notepad++ -> Find All in Current Document as...
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
April 19, 2011 at 7:48 am
Craig Farrell (4/19/2011)
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
April 19, 2011 at 6:50 am
SQL doesn't care what the extensions are.
That said, stick to convention unless you have a good reason. Otherwise you'll just confuse future people.
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
April 19, 2011 at 6:45 am
HowardW (4/19/2011)
2011-04-18 16:15:12.13 spid77 Setting database option RECOVERY to SIMPLE for database MyApp_LIVE_MPV.
2011-04-18 16:15:21.35 spid60 Setting database option...
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
April 19, 2011 at 6:40 am
Generally, by convention, the first file in the DB (the primary file, FileID=1) has the .mdf extension, all others are .ndf. It's purely by convention, you can do as you...
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
April 19, 2011 at 6:26 am
Joseph Fallon (4/19/2011)
I'll have to warn you - we're auditing successful logins and our main user app connects/disconnects very often so there'll be a good bit of scrolling ...
No worries,...
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
April 19, 2011 at 6:21 am
Please post new questions in a new thread and include some details of what you've done.
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
April 19, 2011 at 4:26 am
Sysadmins have access to everything in all databases on the server, no permission can be denied to them,
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
April 19, 2011 at 4:24 am
Don't filter, you could be missing stuff.
Can you copy out (as text) the error log entries between the last successful log backup and the first failed log backup and post...
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
April 19, 2011 at 4:22 am
Check the SQL error log. Likely someone has switched the recovery model to simple then back to full. Doing so breaks the log chain and no further log backups can...
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
April 19, 2011 at 3:39 am
Viewing 15 posts - 26,611 through 26,625 (of 49,552 total)