Chapter 4, Page #149

If SQL Server is forced to operate with an insufficient amount of memory, it will be able

to store fewer data pages in the buffer pool. As...

net start ReportServer

Queries would run slowly.

You need to arrange for enough disk space.

Restored database file size would be same as the backed up file size.

It looks like database 'Audit' has no issues.

Please run DBCC CHECKDB(AuditT) WITH NO_INFOMSGS

You can use single distributor for all the 4 publishers.

Every published database (for transaction replication) will have a log reader agent.

What does the copy/restore job histary say?

Does the SQL Agent service account has read permission to the share?

You should run the Query 2 on a different session (query window).

I believe, upgrade from Standard Edition to Enterprise Edition is possible without removing any features.

Right click on the folder -> Select Properties -> Click on Security tab.

Shriking a 160GB file directly to 30GB takes very long time and causes blocking.

One work around is to shink the file in smaller chunks.

E.g. shink the file by 2GB at...

May be it is backup of a replicated database restored.

To fix this issue, create a dummy replication and remove it.

or try this :

sp_removedbreplication

Please run this:

select log_reuse_wait_desc from sys.databases where name = 'DBName'

Is this tempdb or user db?

After log backup, what is the VSL status? 0 or 2?

SQL Server 2008 has an option called "optimize for ad hoc workloads"

Please see whether is helpful to you.

May I ask why?

You can use cache option to show the same report.