It's possible to have autogrowth enabled, but also have max file size restricting the growth. I think you'd get a different error though.

GilaMonster (6/8/2009)

Internal (index) fragmentation or external (file) fragmentation?

For the first, rebuild your indexes

For the second, stop SQL and run a disk defragmentation tool. Speak to the SAN admins. There's usually...

rvz (6/3/2009)

---

Well, someone recomended this approach to me about a year ago because the log always grew very large in a short time (short time = the size of the...

I didn't try that. Would a user be able to use the command prompt ?

If you set to simple, you...

No open transactions now. DBCC SQLPERF(LOGSPACE) showed 4.5 Gig. I've shrunk it to 1.5 Gig which should be enough. I need to get more disk !

No log shipping, mirroring or replication. I'll have to figure out what type of activity was going on.

Thanks for all the help.

Ratheesh.K.Nair (6/1/2009)

---

Taking backups wont shrink the log files. that is the reason why they grew.

You have to run the dbcc shrinkfile or shrinkdatabase command to reduce the physical size of...

Yes, I can see the database in SSMS GUI, But I get an error if I try to display properties, and there is no + sign to expand it.

"Database MyDatabase...

I cannot get any info on 1 database. sp_helpdb does not list it, although it is in sys.databases

Thanks for the reply

How many databases do you have on this instance?

- 46 including system db

How many of these databases are in full recovery model?

- ...

sysdepends may not be 100% accurate. You might create a stored procedure referencing a table that doesn't exist yet. In that case sysdepends does not get updated.

I was just going through figuring that out today also ! ...

getdate()

When you use the Import/Export wizard, you have the option to append or replace the data ("edit mappings"). You have to go into each table to set it which...