Viewing 15 posts - 44,296 through 44,310 (of 49,571 total)
Matt Whitfield (9/23/2008)
Chirag (9/23/2008)
If...
September 23, 2008 at 2:49 am
Chirag (9/23/2008)
The pages from the source database get written to the snapshot's sparse file the first time the page gets modified in the source database. Is that...
September 23, 2008 at 2:47 am
Mike Metcalf (9/23/2008)
September 23, 2008 at 2:45 am
Given that, you would need to restore in the following order
Full backup
Diff 2
Tran log 1
Tran log 2
The transaction logs form a chain and you need all of the tran log...
September 23, 2008 at 2:34 am
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...
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...
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( '...
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.
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...
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...
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...
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...
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...
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,...
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...
September 23, 2008 at 1:03 am
Viewing 15 posts - 44,296 through 44,310 (of 49,571 total)