Before you set the max memory to 12GB, make sure you have upgraded to SP3 CU4 and enabled the lock pages in memory setting. If you don't, then you...

wmalik001 (5/20/2010)

---

Today, checked the task manager and i saw that sql server service was using 8gb alone,

the min value in mb for memory is set to 0

and the max...

That is normal and the way SQL Server works. It will take as much memory as is needed, up to the max memory setting for that instance.

ErickTreeTops (5/19/2010)

---

The error is "Cannot access the specified path on the server" when trying to set the backup file location.

When attempting a restore the same error occurs.

There must be...

That is normal - it is not actually using the page file and just reporting the memory usage that SQL Server is taking as PF usage.

What are the min/max settings...

While reviewing the transaction isolation levels, review the snapshot isolation section in further detail. If you decide to use that - be sure you understand the additional requirements and...

Lamprey13 (5/19/2010)

---

That might be the right answer. But, when I see stuff like that I wonder if might be a file that is not being used properly? Specifically, a file...

Instead of using TRUE/FALSE (two states), try using a datetime value for when the row was deleted. You can then use NULL to identify the active row - with...

Read the article in my signature on managing transaction logs. If the transaction log is full, I would bet that you are not performing log backups regularly. You...

Or, it is a SAN snapshot technology that is performing a snapshot backup.

These are generally messages related to using the VDI interface to perform backups or snapshots. Do you have a SAN backup utility performing backups on your system?

No, you shouldn't shrink the database files unless you are absolutely sure you will never need that space. Eventually, you will need that space again and the data files...

What version are your client tools - and what version are you connecting to? Those reports are not...

I would recommend looking at synonyms. You define the synonyms for that system and create the views to use the synonyms. That way, when you move the code...

There really isn't any easy way to copy/transfer maintenance plans from 2005 to 2008. It will take less time to just manually create them as needed.