about SQL Server 7.0's Size
I create a database under sql server 7.0. and the data is 60MB log is 30MB
because I use auto increase size.after some time(maybe little long).I found that the log file is 300MB,so I use DUMP TRANSACTION WITH NOLOG,TRUNCATE... want to decrease the log size.but failed. I want to use backup and restore to do that but failed again.Please help me how to resolve it.
Thank you very much