yes, I just check recovery interval and it is 0. one thing i don't understand that only log size is grown crazy, but data size is no chnage basically. ...

yes, the recovery mode is simple. I did full back up, and tried to shrink, did not work. I wonder if it has to do with restart SQL server? thanks...

I had same issue with reportservertempdb, but DBCC SHrinkfile did not shrink for me. here is what I ran:

dbcc shrinkfile(ReportServer2TempDB_log,2048),

currently size is 6GB, I tried to shrank it to...

hello, thanks for your post re same error:"Error 21268 [SQL-DMO]Row or column specified is outside the range of the specified query results set" , so I run " select *...

thanks. it worked for me. I just copied model from other db and reinstalled it. I'm facing side by side upgrade Sql 2000 to sql 2005, so what would be...

sql2000 path E:\MSSQL\Data

sql2005 path E:\MSSQL.1\Data

Against sql2005, I run

select name, physical_name from sys.master_files where database_id = 3

modeldevE:\MSSQL.1\MSSQL\DATA\model.mdf

modellogE:\MSSQL.1\MSSQL\DATA\modellog.ldf

I tried to start sql2000 service with -m -f, but still...

thanks for asking, I am kind of new here. yes, model.mdf and model.ldf are still under data folder of sql 2000. One thing I don't understand is I did not...