depends how often you are seeing the message and if you see the exact same symptons.

If you are at SP3 you should have this hotfix.

try the setup I suggested and...

same place, different entry?

1.On the Start menu, click Run. In the Open box, type gpedit.msc.

The Group Policy dialog box opens.

2.On the Group Policy console, expand Computer Configuration, and then expand Windows...

you should set a max memory limit of 14GB at the most.

then assign the 'lock pages in memory' right to the service account running SQL.

That will require a restart to...

brett.walker (3/29/2010)

---

So, if I shrink the log file on the primary server, the shrink will propogate to the destination server? Right now, my critical issue is freeing up space...

shrinks don't break logshipping. Will hurt your performance though,

You are making changes at the weekend - the reindexing. that as you know causes log activity. At the moment you capture...

its the lock pages in memory that prevents SQL releasing memory to OS, not the max setting. that just sets an upper limit.

See how much memory is available via task...

check with your server admins to see if they have auditing for file deletions turned on, otherwise you are down to checking with those people who have the access to...

brett.walker (3/26/2010)

---

We have index REORGS scheduled every Wed and Sun at 01:00. When this runs, it makes the log file around 40GB on SQL1. That's fine -- we...

why are you trying to do this?

I would be interested to know if this does work, would seem prone to failures on deprecated code to me and I would be...

if the files are spread across separate drives you will get increased throughput. To spread the load evenly between the drives the files would ideally be the same size as...

you cannot logship to a higher version of SQL. The database needs to go through an upgrade stage and any deprecated commands would fail.

all jobs can be scripted from SSMS in one go.

double click on jobs under SQLAgent so the jobs appear in the right hand detail pane. Highlight all jobs (shift/click), then...

are all files in the same filegroup?

gergav33 (3/26/2010)

---

have a look at

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

EMPTYFILE

Migrates all data from the specified file to other files in the same filegroup. Because the Database Engine no longer allows data to be...