nlion84DBA (10/24/2007)

---

Hello

Is it also true that you must be running SQL Server 2005 EE in order to take advantage of the space available by using PAE? Standard Edition cannot...

indeed the whole table is there for backward compatibility, the SQL2005 table is sys.objects

You will also find some other sys------- tables which are for backward compatibility too

if not using windows authentication then you would need to specify the following

EXEC @hr...

Lowell (8/29/2008)

---

when you delete a file, regardless of the recycle bin, the file is still there, but the disk space it used is open for use by other programs...if you...

ohh so true!

Vegard Hagen (9/1/2008)

---

What he should have done is of course to detach the DB, move the files and then...

DMC

we dont use maint plans (they generally are a pain). All our maint\backup jobs are scripted using T-SQL.

Any database maintenance ops should be carried out before a backup. As Gsquared...

first thing is to ascertain if anything was inside the missing file.

start by querying the sys.sysindexes table and sort by filegroup id. Get the file group id of the missing...

i too have seen this before.

SQL server loves RAM, give it the amount you think it will need. if it requires more then add extra sticks

via active directory!!

in an ideal world 😉

the following will forcefully shrink the logfile, set recovery model to FULL first

--Forcefully Reducing the Size of the SQL Server Log File

--(These instructions are rooted in SQL Server 7, but...

Waseem Jaleel (8/28/2008)

---

Yes I need to, but not all the users. I need to keep 5 users , and remove the rest. To drop these users, I need to first...

yes, that is correct. The first 70% of the log is unused, the active portion (status of 2) would prevent the log from shrinking to a realistic size. What is...

your original post above indicates you need to drop users who own views??

ang

what is the output of the following query run against your database?

DBCC LOGINFO