Viewing 15 posts - 751 through 765 (of 860 total)
Awesome Lowell!!:cool:! Thanks a lot for sharing.... thats a good work....keep going.......:D
February 7, 2009 at 1:09 pm
Jonas (2/7/2009)
Yes.My question is still: if I delete 240MB data, why does the transaction log grow by 15GB?
It was already answered in this:
In your statement there is no commit...
February 7, 2009 at 12:59 pm
"DELETE T1 WHERE T2ID=NN"
Is this statement causing you to delete 8M rows???
According to msdn:
Log records in the transaction log files are truncated on a transaction-by-transaction basis. If the transaction...
February 7, 2009 at 12:37 pm
How are you deleting the rows? Are you deleting with a single DELETE statement or are you deleting the rows as batches. If you delete as a single statement then...
February 7, 2009 at 12:13 pm
DELETE statement is fully logged by SQL server, so when you are deleting 8M rows then each row operation is logged into tlog. If you do not want to be...
February 7, 2009 at 11:58 am
My Pleasure!
Please do post if you have any errors, we would be able to help you out
February 6, 2009 at 2:18 pm
n.yarramreddy (2/6/2009)
Bakcup the Acitve portiong of the log(Tail log)-how to take the tail log backup(Command)..........?
BACKUP LOG WITH NO_TRUNCATE
Look in BOL to understand the concept before working on it.
February 6, 2009 at 12:45 am
Did you just change one row? You are lucky, Just revert back the value.
You can restore the database to the earlier time but since its only one row, I would...
February 6, 2009 at 12:21 am
What are your tasks though? Is it just connecting to the database. Could you provide us with more info?
You can do this in many ways:
Linked server
Replication
Logshipping
DB Mirroring
Failover Cluster
But what is...
February 6, 2009 at 12:17 am
The Order goes like this:
Bakcup the Acitve portiong of the log(Tail log)
Recent Full backup(No Recovery)
Recent Differential backup(No Recovery)
Latest Tlog backup(No Recovery)
and finally Tail Backup with STOPAT (Recovery)
February 6, 2009 at 12:04 am
Krishna (2/5/2009)
I have a job to rebuild indexes..this increases the transaction log size....so i want to truncate it...
How frequent do you rebuild your indexes. There will be heavy logging while...
February 5, 2009 at 11:41 am
sridhar.tondapi (2/5/2009)
yes,my transaction got committed...i guess i need to perform recovery.
Then, Restore it to a different database name and copy the table to the target database.
February 5, 2009 at 4:54 am
And one more thing if you are feared that something would go wrong when you change it is always a good practice to backup your data before any change, you...
February 5, 2009 at 4:50 am
Do you have any backups taken? If so, you can restore it to a different database and copy the table to the database which lost the data.
February 5, 2009 at 4:44 am
How many clients are going to be there and how many instances(maximum 50 instances in Enterprise) are you going to maintain obviously an overhead to administration. I don't think its...
February 5, 2009 at 4:39 am
Viewing 15 posts - 751 through 765 (of 860 total)