Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nitin05.sharma
Starting Member
20 Posts |
 Posted - 2015-03-30 : 06:03:16
|
| hello everyone,i am finding the error " SQL Server 9002 transaction log full" while doing the partitioning the table.Note: This error occured after the 30 min execution of table partitioning scriptThanks In AdvancePlz help its very urgent |
|
|
Kristen
Test
22859 Posts |
Posted - 2015-03-30 : 07:08:52
|
| Backup the Transaction Log every minute during the execution of the script? |
 |
|
|
nitin05.sharma
Starting Member
20 Posts |
Posted - 2015-03-30 : 07:57:55
|
| Thanks for reponseyes we doing same i have checked the autobackup property true.can you plz how we can pause this transaction |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2015-04-01 : 04:18:48
|
quote:
Originally posted by nitin05.sharma
i have checked the autobackup property true.
I'm not familiar with that, can you explain what that is please? |
|
|
|
|
|
|
issue with doing the table partitioning