Viewing 15 posts - 12,541 through 12,555 (of 22,214 total)
Anjan Wahwar (5/17/2011)
Grant Fritchey (5/17/2011)
May 17, 2011 at 7:28 am
Jeff Moden (5/17/2011)
Grant Fritchey (5/16/2011)
Jack Corbett (5/16/2011)
May 17, 2011 at 7:27 am
buferis12 (5/17/2011)
ahh thats bad 🙁 SO reverse engineering wouldn't help too? Btw, yeah there is things called stored procedures in that db.
There you go. You can't possibly know what's going...
May 17, 2011 at 5:24 am
Without a transaction, a rollback of a delete statement requires you to have already stored the data elsewhere. If you really need complete recovery and you're working within DTS, why...
May 17, 2011 at 5:12 am
GilaMonster (5/16/2011)
Grant Fritchey (5/16/2011)
May 16, 2011 at 2:13 pm
I don't know, we'll have to renogiate the rate now...
Here's a little query to just get you started:
SELECT bf.logical_name,bs.backup_finish_date
FROM dbo.backupfile AS bf
...
May 16, 2011 at 2:10 pm
Jack Corbett (5/16/2011)
May 16, 2011 at 1:47 pm
Yeah. That way you don't have to guess what the backup name is.
May 16, 2011 at 1:44 pm
You could use SSIS and schedule it from SQL Agent. You could use a PowerShell script and run that from SQL Agent. You could probably use a linked server and...
May 16, 2011 at 1:15 pm
Problem is, that includes the time too. No way to calculate that, you have to know it.
Do you have access to the server where the backups are being taken? You...
May 16, 2011 at 1:13 pm
You'll be able to make guesses on the table structures if, and only if, you have all dynamic TSQL. If they're calling stored procedures you will have absolutely no mechanism...
May 16, 2011 at 12:05 pm
Ninja's_RGR'us (5/16/2011)
Ninja's_RGR'us (5/16/2011)
What's the advantage of setting the db or files to read_only?.. and which ones do you set ro?
Ya, but if the db only has selects running on it,...
May 16, 2011 at 8:42 am
GSquared (5/16/2011)
I went. There were a number of good presentations. Definitely worth the time spent and all that. Learned more than a little bit.
And I got to...
May 16, 2011 at 8:39 am
Gail said it. Read only not only means it doesn't take out locks, but it stops trying to. Changes the dynamic on queries considerably. Huge advantage for read only systems....
May 16, 2011 at 8:38 am
Viewing 15 posts - 12,541 through 12,555 (of 22,214 total)