Viewing 15 posts - 13,366 through 13,380 (of 49,552 total)
I think a lot more information is needed to say anything useful. Oh, except for the fact that changing temp tables to table variables will do nothing for locks.
April 23, 2013 at 1:10 pm
If you know the time of the deletes that you want to 'undo' (or you can work it out), STOPAT will most definitely work. If you want to go buy...
April 23, 2013 at 12:28 pm
pbowman-543344 (4/23/2013)
The question is, what happens when statistics on NORECOMPUTE set tables go stale?
Nothing.
Stats with norecompute will not be automatically updated, hence when they pass the threshold, nothing happens, they're...
April 23, 2013 at 11:24 am
pdanes (4/23/2013)
April 23, 2013 at 10:01 am
In that case, if you know the exact time that the rows were deleted you should be able to take a log backup now, restore teh initial backup WITH NORECOVERY...
April 23, 2013 at 9:28 am
Those two aren't equivalent, the second has a join that the first does not.
The equivalent with exists would be
select *,'I' from pharmdb.pat.dbo.patients po where NOT EXISTS (SELECT 1 FROM Patients...
April 23, 2013 at 9:05 am
As I said, the full backup is not what caused that data to not be restorable.
To restore that, you need to have a full backup that was run before the...
April 23, 2013 at 8:38 am
pdanes (4/23/2013)
So a backup is a 'snapshot' from the moment in time that the backup process was initiated? And operations performed during the backup process do not get incorporated?
No, not...
April 23, 2013 at 8:35 am
Ice007 (4/23/2013)
GilaMonster (4/23/2013)
Shrink to X GB (where X is the size the log needs to be for normal operation)
Thanks Gila I did backed up my data but not the log,...
April 23, 2013 at 8:33 am
Go and take a look at what the commands are that reference that hidden DB. You'll notice that there's no references to user tables, no user procedures, they'll all be...
April 23, 2013 at 8:31 am
To recover that data, you'd need to be able to restore (via log backups) to a point between the data being inserted and being deleted. Since you don't have those...
April 23, 2013 at 8:28 am
pdanes (4/23/2013)
What state are such backups in when they are taken?
The same state they would be in if they were taken without a full/diff running
What does a transaction log backup...
April 23, 2013 at 8:22 am
Run the following, post the full, complete and unedited output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
No clean backups at all? Someone's not doing their job properly.
April 23, 2013 at 4:39 am
You won't be able to take the database offline with a session still rolling back. Restart the SQL instance, that will remove that SPID, then you'll have no trouble taking...
April 23, 2013 at 3:40 am
http://www.google.com/search?q=What+is+the+system+resource+database
DBID 32767, no all commands do not run against it. But then, why do you think most queries in cache should have run against database 5?
April 23, 2013 at 3:28 am
Viewing 15 posts - 13,366 through 13,380 (of 49,552 total)