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.

 All Forums
 SQL Server 2012 Forums
 Other SQL Server 2012 Topics
 issue with doing the table partitioning

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 script

Thanks In Advance

Plz 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?
Go to Top of Page

nitin05.sharma
Starting Member

20 Posts

Posted - 2015-03-30 : 07:57:55
Thanks for reponse

yes we doing same
i have checked the autobackup property true.

can you plz how we can pause this transaction

Go to Top of Page

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?
Go to Top of Page
   

- Advertisement -