yes

once again, thankyou.

unless you have a profile trace (perhaps the default trace) from when it was done I do not know of a way to do that (would say it was impossible)

the...

most likely this user has been added to the model database. As all new databases are created from the model database this user would get added to all databases that...

That's interesting info. I work for a software vendor, we're always trying to work out different workloads... it's why I asked here because this is where the experts hang out!...

lindsey.keen (7/7/2009)

---

another point that may or may not be useful. there are a couple of databases that have a 5gb log file, when you use DBCC SQLPERF(logspace) it says...

lindsey.keen (7/7/2009)

---

It...

cheers, no problem

sqlbuddy123 (7/6/2009)

---

Hi,

I have multiple databases on each SQL Server 2005 instance on a Cluster that need to be...

looks like you are good to go. Of course what values you shrink to after the truncateonly will depend on what effect the truncateonly actually has, might chop a lot...

jason.stephens (7/6/2009)

---

Currently the database is at 67 GB. I need it around 25 GB. Would the following be an exact example of what you are saying? T-SQL correct?

-- STEP 1-----------------------------------------------------------------------

USE...

reindex jobs can produce a lot of transaction log activity, especially if a database is dominated by one large table. check log usage during your reindex window.

If you are not already, use shrinkfile rather than shrinkdatabase.

Take a backup, put the database in bulk_logged mode, shrink the database file in chunks , not one big go, and...

check out these two posts:

http://www.sqlservercentral.com/Forums/Topic622641-146-7.aspx

http://www.eggheadcafe.com/software/aspnet/29328807/cannot-install-sql-server.aspx

you may have to use the Windows Installer Cleanup utility to tidy things up and then reinstall.

make sure you back everything up.

I presume you mean you cannot see them through the application?

did you also copy across the logins to your new server? If not you need to do so, best way...