What service account do you use to start SQL Server and Agent services? Is it in local administrator group?

Do not set set working set size if you are allowing SQL Server to use memory dynamically. Before setting set working set size to 1, set both min server memory...

Do you mean database available space is 0.00MB? Try to run sp_spaceused @updateusage = true to the database and go back to check it.

Does the login you used have permission to run this command? Can you post exact error message from QA?

What version of SQL Server and service pack are you running?

Try to start SQL Server with minimal configuration from DOS with 'sqlservr -c -f' and run sp_configure to change it back.

I think service pack touchs only system databases. You need to watch the performance after the movement and maybe have to update database statistics and perform optimization to your database.

...

What error messages show in SQL Server errorlog?

Each time server is rebooted, A new SQL Server errorlog will be created with startup informations that indicate SQL Server is restarted. In privious errorlog, A message 'SQL Server is...

1. Pass-through query

2. Programming Modules in Access using VB.

SQL Server Agent maybe fail to start after fail-over. Check SQL Server Agent log (Display error log) from EM and review machine application/system logs too.

Use pubs as example. I have added second filegroup (secondgroup) and senond file (pubs2) to the secondgroup. Now, run following commands to remove the second filegroup.

dbcc shrinkfile(pubs2, emptyfile)

alter database pubs...

Before removing a filegroup, you need to know which files are in this filegroup and empty these files and then remove them.

Create clustered index to the table.

No ideas how they produce the report. They might trace the logins by examining transaction log or using Profiler to trace who are accessing SQL Server and create histroy logs...