It seems to be OK.

I get a decent looking error screen and not just a nasty 404 page or something, and if I just go to http:/// I...

Jeffrey Williams (7/17/2009)

---

Jason Shadonix (7/17/2009)

---

If I'm counting over to the right column, then for the data file you have 856 Pages (under 8MB) and only have 96 Pages (< 1MB)...

If I'm counting over to the right column, then for the data file you have 856 Pages (under 8MB) and only have 96 Pages (< 1MB) in the log file....

Maybe run this:

select * from msdb.sys.database_files and post the results?

Also might be worth considering turning the default auto-grow settings off or resticting the growth quite a bit. In...

Since this is a dev/test box, might try making the model database read-only and see what breaks.

h_maksuda (7/16/2009)

---

I'm worried about my model db log file. And I'm not using this bd for anything still it's growing faster.

So I'm worried. What causing my model log...

Thanks for the tips. Turns out I'm dense, and had the FullText service for another instance started, but not the instance I was installing on. Once I started...

Mani Singh (6/17/2009)

---

What are the SQL Server Service accounts (local or domain accounts)

Are the DB compatibility modes same for both the databases.

What is the service pack levels and SQL server...

But isn't the timeout error...

Thanks for the links. That first one is interesting. I saw a couple of others saying they were having backup troubles on the principal server with database mirroring...

I also just noticed a bunch of these in yesterday's log: Downgraded restore buffers from 4096K to 2048K. (hundreds of them).

I see another post on this site with that...

I did something somewhat similar several years ago. We just set up a linked server in SQL pointing to the AS/400 databases.

We didn't use SSIS or DTS...

Interesting, I didn't know that.

Just for fun I just created a dummy table with a VARCHAR column that I didn't specify the length for, and it made it of length...

Didn't we have a question about how many instances you can install a few months ago? Or was the one I'm thinking of for 2005?

Have you run a DBCC on the database prior to detatching just to make sure all is OK?

Also, can you create a dummy database on that S: drive to make...