Solved

Delete Replication for Publisher and Subscriber

Posted on 2004-03-22
1
1,685 Views
Last Modified: 2007-12-19
Since we don't have enough space for publisher to do the replication job, I would like to delete the replication for both Publisher ans Subscriber.

I delete the subscription from subscriber successfully. And then I am trying to delete it from the publisher, get the error 9002: (SQL Server Enterprise Manager could not delete the subscription at Subscriber in database) The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some Log space.

Can anyone tell me how to free up some log space and how to delete the replication for both publisher ans subscriber?

Thanks a Lot!
0
Comment
Question by:Skaugen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 13

Accepted Solution

by:
danblake earned 500 total points
ID: 10650696
The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some Log space.

You need to increase the space on the server, normally tempdb log file will continue growing or alternativly add an additional log file for tempdb on a spare drive where some space is.

Option : Delete some files where log currently exists/create new log.
(+Check autogrow is enabled or the tempdb log file has sufficient space).

Or alternativly restart the server, to empty tempdb (emergency fix only -- does not stop the problem happening again in future as this resets tempdb to its initial space size).
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSRS  - Parameters with comma 10 40
TSQL remove duplicates from different columns 14 52
Remove () 10 40
SQL - Aging Report - Display Months with no data 8 43
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question