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

why not change all the view ownerships using sp_changeobjectowner,

once done then drop the users 😎

if you want to find disk space used on a server you could try a WMI query to get the info required.

Alternatively try BGInfo utility from sysinternals

its not quite as simple as that

do you mean

active\active

or

active\passive

yes and this message is fairly descriptive,...

my guess is 1 of the filegroups is already empty.

check your filegroups to see which are in use!