BACKUP LOG PackCheckNewTest TO disk ='f:\loglsn\log.bak' GOUSE AdventureWorks; GO -- Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE AdventureWorks SET RECOVERY SIMPLE; GO -- Shrink the truncated log file to 1 MB. DBCC SHRINKFILE (AdventureWorks_Log, 1); GO -- Reset the database recovery model. ALTER DATABASE AdventureWorks SET RECOVERY FULL; GO
对你的数据没有什么影响啊直接修改就行啦
'T_PCStandardBill' 表
- 不能修改表。
ODBC 错误: [Microsoft][ODBC SQL Server Driver][SQL Server]数据库 'PackCheckNewTest' 的日志已满。请备份该数据库的事务日志以释放一些日志空间。这个要如何处理啊,
TO disk ='f:\loglsn\log.bak'
GOUSE AdventureWorks;
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE AdventureWorks
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (AdventureWorks_Log, 1);
GO
-- Reset the database recovery model.
ALTER DATABASE AdventureWorks
SET RECOVERY FULL;
GO
alter table tb
alter column [name] varchar(50)