Viewing 15 posts - 61 through 75 (of 119 total)
GSquared (3/2/2011)
Are there incomplete/uncommitted transactions showing?
dbcc opentran() shows "No active open transactions."
The database has a full backup Sunday night, differential Mon-Sat, and logs are backed up every 15 minutes.
Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS
March 2, 2011 at 8:11 am
As you wish.
-- --
[font="Courier New"]CREATE TABLE [dbo].[ActivityLog](
[ActivityLogId] [bigint] IDENTITY(1,1) NOT NULL,
[InstitutionCode] [nvarchar](10) NOT NULL,
[EnvironmentName] [nvarchar](50) NOT NULL,
[ServiceRqUID] [uniqueidentifier] NOT NULL,
[MessageRqUID] [uniqueidentifier] NOT NULL,
[RqDate] [datetime] NOT NULL,
[RsDate] [datetime] NULL,
[Signon_SPName] [nvarchar](50)...
Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS
March 2, 2011 at 8:07 am
The tables being purged contain ZERO rows. (Refer to the attached JPGs.) The data is in fact purged, but the disk space is not behaving like it's available.
Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS
March 2, 2011 at 7:46 am
GSquared (3/2/2011)
Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS
March 2, 2011 at 7:32 am
As I said previously, a cluster is either active\passive or active\active. This link from MS provides an overview of the 2 cluster operating modes and the terminologies!
From the link you...
Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS
October 29, 2010 at 7:26 am
Steve Jones - Editor (9/10/2010)
Create role MyDenyRole
Then I'd...
Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS
September 10, 2010 at 9:04 am
rmechaber (9/10/2010)
Mike Hinds (9/9/2010)
What we finally did was:[font="Courier"]EXEC sp_msForEachTable 'DENY SELECT ON ? TO [TheUser]'
GO
GRANT SELECT ON [dbo].[AllowedTable] TO [TheUser]
GO[/font]
For anyone considering this, sp_msForEachTable is "non-supported".
But what happens when you...
Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS
September 10, 2010 at 8:55 am
What we finally did was:
[font="Courier"]EXEC sp_msForEachTable 'DENY SELECT ON ? TO [TheUser]'
GO
GRANT SELECT ON [dbo].[AllowedTable] TO [TheUser]
GO[/font]
For anyone considering this, sp_msForEachTable is "non-supported".
Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS
September 9, 2010 at 3:29 pm
Perry Whittle (8/6/2010)
Mike Hinds (8/5/2010)
but manually bringing either online does nothing for the other.then you do not have your dependencies set correctly!
see my attached screenshot for details
Thanks for the screenshots,...
Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS
August 6, 2010 at 5:15 am
Perry Whittle (8/5/2010)
Bringing the SQL Server agent online first will automatically bring SQL Server up due to the dependencies between these resources 😉
Not on any of my clusters (I have...
Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS
August 5, 2010 at 8:04 am
No need to failover to restart the SQL service. From Cluster Administrator, select SQL Server resource, then "take offline", followed by "bring online". Remember to "bring online" for SQL Agent...
Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS
August 5, 2010 at 5:53 am
Relevant to the topic - a useful and fun file utility is WinDirStat. It's also really great example of displaying file space by single-file and by folder hierarchy, of where...
Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS
August 4, 2010 at 1:18 pm
Symantec Backup Exec is known to do this to SQL instances. The only way I know to prevent it is to remove NT AUTHORITY\SYSTEM (but don't do it!)
It messes up...
Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS
June 30, 2010 at 5:33 am
Thanks to all for the ammunition.
Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS
June 28, 2010 at 7:02 am
Still, rebar in concrete won't crumble, unlike its T-SQL counterpart.
Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS
April 27, 2010 at 6:57 am
Viewing 15 posts - 61 through 75 (of 119 total)