the default setting for max server memory is 2147483647 megabytes (MB). The minimum amount of memory you can specify for...

Did you try this?

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'max server memory', N; -- Change N to suite your needs

GO

RECONFIGURE;

GO

Server Memory Options

http://msdn.microsoft.com/en-us/library/ms178067.aspx

Note: This feature (Enabling AWE Memory for SQL Server)will be removed in the next version of Microsoft SQL Server. Do not use this feature in...

Chris Metzger (11/22/2011)

---

Jim Murphy (11/22/2011)

---

Ah, I see.

If disk space permits, it is always a great idea to retain more. Moving those backups off to tape/NAS throughout the...

Creating a format file would be a good idea.

Creating a Format File

http://msdn.microsoft.com/en-us/library/ms191516.aspx

Sample File:

10.0

4

1 SQLSMALLINT 0 2...

Just to list a few...

•It would be...

COPY ONLY backups don't disturb backup chain. If you are trying to match LSN with other backups, it won't.

Create a Job / SSIS package for it.

You can optionally write bat / cmd files.

I would say it overconfidence. Overconfidence results in ignorance and that’s...

I assume you have gone through this article.

Before Installing Failover Clustering

http://msdn.microsoft.com/en-us/library/ms189910.aspx

If No, please go through it now & try again.

If Yes, verify each of your steps with the article given...

T_VR (11/22/2011)

---

Thanks Dev,

The main advantage for me was that this is something that is used often within queries and this solution could have made the report not hit the fact...

Please don't create duplicate threads...

http://www.sqlservercentral.com/Forums/Topic1210091-391-1.aspx

Jim Murphy (11/22/2011)

---

What gap do you see?

He's doing a full backup every 24h and...

Very Funny Jim. Second line was for other SSC friends 😛

I never tried it (preferred it)....