The transaction log in database sales is almost full. Your transaction is being suspended until space is made available in the log.
Will be repuduced whan trying to work with a table in the database.
Cause:
Log space is full.
Check it using:
sp_helpdb <DBNAME>
sp_helpdevice <DEVICENAME>
Solution:
use master
go
disk resize name = "<DEVICENAME>", size = "500M"
go
alter database sales log on <DEVICENAME> = "500M"
go
No comments:
Post a Comment