Did you check syscolumns table?

Wheather or not data is NULL does not matter to the space in data pages. Only does DATATYPE affect it.

Did you try

ALTER DATABASE ... -- for database level

ALTER TABLE ... -- for table levle

DId you try

RESTORE HEADERONLY FROM backupDevice

Unused space cannot automatically released.

Did you try DBCC SHRINKDB command?

After changing the password for the SQL Agent, you need to restart it.

Or you may go to the Properties of SQL Server Agent, click Reset Proxy Account under the tab,...

Check the link below.

http://sql-articles.com/articles/eval2entupgrage.html

May it help.

Do you use Local System account? If so, try to use other account as sysadmin.

Network jam does affect your request.

I believe your server experienced an unexpected termination. It roll-forward for uncommitted transactions after restarted.

Check free space on your database server. If it has enough, check your tape server.

It is possible.

Create a database device, then backup your database to this device.

Check ALTER DATABASE clause if you would like to change it on a database level.

Check ALTER TABLE clause if you would like to change it on either table level or...

Do you mean you have 235 log files?

As far as I know, your primary and secondary servers should be enterprise editions unless you develop your own scripts.

Also, you need to make sure that you have a stable...