This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / SQL Server backup question有个database, 总被backup/restore (only database backup, no transaction log file backup). 所以the log file 现在就庞大无比。更可气的是现在也没有办法作log file backup 了。
请问有什么办法可以恢复transaction log file backup?
-zxcvb(朝天椒);
2003-10-10
{220}
(#1407457@0)
-
truncate
-expertune(伪劣);
2003-10-10
(#1407518@0)
-
USE yourDBName;
BACKUP LOG yourDBName WITH NO_LOG;
DBCC SHRINKFILE (LOG, 1);
-mutantx(阿吉);
2003-10-10
(#1407540@0)
-
thanks. This is what i did1. dbcc shrinkdatabase (Mydb)
2. backup log Mydb with truncate_only
3. backup log Mydb to MyDevice
Anyway, my log file is much much smaller than before and i can do the log file backup using enterprise manager.
-zxcvb(朝天椒);
2003-10-10
{216}
(#1407560@0)
-
You can also limit your log file size in the enterprise manager database properties.
-mutantx(阿吉);
2003-10-10
(#1407679@0)
-
I'll do it. Thank you very much.
-zxcvb(朝天椒);
2003-10-10
(#1407687@0)