Why do you want to test in a production environment? Set up a test environment for testing and leave production alone.

Thanks

Increase the frequency of the log backups rather than increasing the disk first. Schedule them to run every hour or more frequently if needed (depending on your RPO).

Thanks

Is this on a production or non-production environment? What tasks do they do on the databases? Once you've identified this then you can restrict their permissions as it's not a...

You're welcome.

It's good you still have the certificate. There is a guide to removing TDE here:

http://www.sqlservercentral.com/articles/Security/76141/

Thanks

Right so it looks as though it won't come online because the certificate was deleted. What steps did you take yesterday to remove the encryption?

Thanks

Is there enough space on the disk for your database to come online? Was the database shutdown? Have you tried to move the log file recently?

You need to...

Yes you can but you'll lose any data since the full backup was taken unless you also have the log backups.

Do you know what the problem with your...

I would say yes you would be fine but it's always best to check with your licensing vendor first.

Thanks

Have you tried disabling the default trace then re-enabling it? I know this sounds pretty basic but it might work.

Thanks

Have you had any space issues on any of the disks recently?

You can also check the location of the trace file through the registry:

HKEY_LOCAL_MACHINE\Software\Microsoft\<InstanceName>\Setup\SQLDataRoot