Viewing 15 posts - 44,281 through 44,295 (of 49,552 total)
Input buffer only returns the name of the stored proc, if it is a stored proc that's running. If it's an ad-hoc SQL batch, it will return the query
If 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
September 23, 2008 at 2:30 am
Ahmad Osama (9/23/2008)
vyas (9/23/2008)
Yes you can restore.what if the transaction log back up is taken after the 3rd differential bachup
When was the previous log backup taken?
Or when was the log...
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
September 23, 2008 at 1:44 am
bhuvnesh.dogra (9/23/2008)
i need to pass spid as parameter
so its giving error :
declare @spid int,@lstr varchar(100)
set @spid = 52
set @lstr = 'insert into Sp_info dbcc inputbuffer( '...
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
September 23, 2008 at 1:43 am
You should be able to. You'll have to have all the log backups made from the second diff backup, right up to where you want to restore to.
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
September 23, 2008 at 1:30 am
Phil Melling (9/23/2008)
All the more reason for me to read up some more on them! 🙂
:hehe: When I get a chance I'll try and finish the follow-up to this article...
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
September 23, 2008 at 1:28 am
What's the message that was written into the error log?
You can shrink the log while people are on the system, but you shouldn't be shrinking the log at all.
How...
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
September 23, 2008 at 1:25 am
Ahmad Osama (9/22/2008)
tho i think that these are the core DBA fields and each one shud hav pratical knowledge of them....
That's a very narrow view of the DBA role. Personally...
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
September 23, 2008 at 1:22 am
bhuvnesh.dogra (9/23/2008)
i need to store DBCC results in a table for auditfor ex:
Create table Sp_info (Eventtype varchar(50),parameters int,eventinfo nvarchar(max))
insert into Sp_info
dbcc inputbuffer(51)
Can somebody help me ???
insert into Sp_info
EXECUTE('dbcc...
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
September 23, 2008 at 1:16 am
Those look good.
Can you monitor the stats as well as watching for blocking during the known slow time?
Perhaps also run profiler for a while and see if you can correlate...
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
September 23, 2008 at 1:10 am
Thanks. Glad you liked it.
Just one thing though. Snapshots are not a backup strategy. They're great for rolling back accidental changes, but if the source DB is damaged, dropped, corrupted,...
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
September 23, 2008 at 1:06 am
Jeff Moden (9/22/2008)
Do they still have "C2 Auditing" in 2k5? If so, that would probably do it.
They do. It's maybe overkill for checking when users log in. It logs...
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
September 23, 2008 at 1:03 am
joannapea (9/22/2008)
Just wondering if you have any clever suggestions for preventing the login trigger from stopping logins altogether? I've written a trigger which logs all logon activity to a...
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
September 23, 2008 at 12:53 am
Jeff Moden (9/22/2008)
I'm sorry I missed it... Congrats on the 6k milestone, Gail. 🙂
😀 Thanks.
Working from home means I can keep a better eye on the place. :hehe:
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
September 23, 2008 at 12:43 am
Jeff Moden (9/22/2008)
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
September 23, 2008 at 12:37 am
Jeff Moden (9/22/2008)
GilaMonster (9/8/2008)
Turn autoshrink off!Heh... Daaannngg Gail! Didn't know you could shoot porkchops that hard! 😀
:hehe: I prefer paw-paws. So much easier to aim.
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
September 23, 2008 at 12:34 am
Viewing 15 posts - 44,281 through 44,295 (of 49,552 total)