the OP doesn't say...

Now when you say " Set the log to the size it needs to be to handle your activity, set a sensible growth factor and leave it there. " I...

ensure the sql service account has full control permissions on the E:\sqldata directory.

You will need to restart the instance for the change to take effect.

Delete the old files after successful...

first of all there is no point repeatedly shrinking the log if it just having to grow again - and shrinking a log does not remove data from it.

From what...

Zeal-DBA (4/18/2013)

---

thanks for your valuable comment on it.

But what if client ask to create at least one index on each table which are not even suggested by missing index DMV.

he...

how long is for ever?

One thing that report does not take into account is the no. of pages. An index with only 2 pages is not worth rebuilding or even...

prashanthreddymr (4/17/2013)

---

I could see PAE is enabled in the boot.ini file as this is the 64 bit machine. Can you please suggest me removing of the PAE from boot.ini and...

yes a reboot is required.

Where did you get the 2.3GB reading from,...

dkschill (4/17/2013)

---

So I ran:

DBCC CHECKDB() WITH DATA_PURITY

On a recently restored test DB and it ran with no errors. Should I go ahead and schedule a production run? It...

you can but its of minimal use to you with a physical limitation of 4GB on the server.

what makes you think you are running out of memory?

How much memory is...

sounds like there are connections to the database preventing you restoring to it.

in my experience pausing the node causes it to fail the pre-installation checks.

removing from possible owners is the best way to go.

in failover cluster manager, select the SQL service.

right click the server name select properties. possible owners are on the advanced policies tab. Untick the passive node.

don't remove the node from...

hows this as a starter?

select * from master..sysdatabases where databasepropertyex([name], 'status') != 'online'

you can use AWE with 32bit SQL on a 64bit OS.

http://sqlblog.com/blogs/argenis_fernandez/archive/2012/12/30/the-myth-around-32-bit-sql-server-instances-on-64-bit-operating-systems-and-awe.aspx