Viewing 15 posts - 691 through 705 (of 860 total)
kladibeeto (2/16/2009)
If you backup log with truncate only and after that perform full backup you didn't lose anything of data.
Why do you have to truncate the log anyway??Tuncate...
February 16, 2009 at 12:28 pm
chileu17 (2/16/2009)
GilaMonster (2/16/2009)
digitalox (2/14/2009)
GilaMonster (2/14/2009)
Simple recovery has no effect on what's written to a DB's log. Just how long it's retained after it's written.
Good point, not sure why but I've...
February 16, 2009 at 11:14 am
Magy (2/16/2009)
Ok, all I see is FULL in the backup_type. How do I turn on transactional logs?Thanks!
Which means you don't have Transaction log backups. Then, you can only...
February 16, 2009 at 8:37 am
Magy (2/16/2009)
How do I know if I have any transaction logs?Thanks for all the input!
Query the "backupset" system table in msdb databse.
February 16, 2009 at 8:26 am
kladibeeto (2/16/2009)
Conclusion:If You DON'T perform transactional log backup's
You need to do this:
Execute:
BACKUP LOG DatabaseName with truncate_only
DBCC SHRINKFILE (FILENAME, 1000)
And don't conclude anything, not a best practice. We are...
February 16, 2009 at 8:20 am
kladibeeto (2/16/2009)
Hi,Please explain me which log chain will he break if he don't work transactional log backups?
Here a clean explanation from Gail's excellent article "Managing Transaction logs":
"Log chains
Log backups...
February 16, 2009 at 8:08 am
kladibeeto (2/16/2009)
It seems that You didn't understand my post.
I well understood your post and also OP's post
You can't perform point in time backup without transactional log backup and if...
February 16, 2009 at 8:00 am
eashoori (2/16/2009)
Thanks so much, it was not negative. Cna you tell me what do you suggest for tranact log backup schedule?
It really depends on your businesss needs and how much...
February 16, 2009 at 7:50 am
kladibeeto (2/16/2009)
Hi,Please explain me which log chain will he break if he don't work transactional log backups?
log chain for backups. LSN's will go out of order, which means you...
February 16, 2009 at 7:34 am
You can run this script to see how much your SQL server utilizing CPU:
DECLARE @CPU_BUSY int, @IDLE int
SELECT @CPU_BUSY = @@CPU_BUSY, @IDLE = @@IDLE WAITFOR DELAY '000:00:01'
SELECT (@@CPU_BUSY - @CPU_BUSY)/((@@IDLE...
February 16, 2009 at 7:22 am
That's cool and a good work but if you post it int he Scripts section, many would be benifited from your script and also your name will appear when published...
February 16, 2009 at 7:17 am
homebrew01 (2/16/2009)
February 16, 2009 at 6:24 am
Ninja's_RGR'us (2/16/2009)
Yes I got that, can you post the precise steps to go about doing that so that he can make sure to not screw it up?
😀 Me too excited...
February 16, 2009 at 6:18 am
kladibeeto (2/16/2009)
Execute:
BACKUP LOG DatabaseName with truncate_only
DBCC SHRINKFILE (FILENAME, 1000)
Not at all. Truncate_Only option is disastrous. Please do not use this option as it breaks the log chain of the backupsets....
February 16, 2009 at 6:10 am
GRANT REFERENCES ON SCHEMA :: dbo TO guest
Guest User account is a dangerous account. I would not grant any permissions to it. Why dont you create a login for this...
February 16, 2009 at 6:04 am
Viewing 15 posts - 691 through 705 (of 860 total)