Bru Medishetty (2/10/2010)

---

GT-897544 (2/10/2010)

---

I agree with Gail, but diff backup takes almost same time and space as full backup again it depends. Personally i would prefer full back every night...

No, Just you will not have all the features which are included in latest or new SP.

Duplicate, Sorry!

EnjoY!

No, Just you will not have all the features which are included in latest or new SP.

EnjoY!

You shouldn't see any issues with SQL servers.

EnjoY!

I am not sure about the error message.

These steps works great for us, try this.

Ensure that Task Scheduler Service was running on both nodes.

...

We encountered this problem before, that is why we are following this track now it saves lot of bandwidth on network side.

Note: Make sure you don't do this while...

In SQL version is 2005\2008 Auto update statistics option is set 'on' by default at database level, no need to update stats frequntely, and also remember updating statistics causes queries...

Try this, Do you have SA role in Server B? Try to create Domain account with SA role, assign that domain user as job owner, should work. If not let...

Short term solution: Is to take backup and see if it frees log file if Recycle SQL Services.

Long Term Solution: Make sure TempDB is set to autogrowth and DO NOT...

I agree with Steve, Make sure you allocate atleast 2GB for OS and allocate remaining memory to SQL. Go from there and see how it goes.

EnjoY!

Why do you think there is more activity on TempDB? Is there any specific reason? Most of the time TempDB activity is high during Rebuild index job or Back up...

Why not? Many new features to mention. There are lot of new feature in SQL 2008, few among them are inbuilt compression option, usage reports for CPU\Memory\Disk utilization inbuilt with...

Did you run log back up after deleting records? Did you shrink data\log file? Check MDF and LDF file size before and after log back up.

EnjoY!

Did you try to back up to another drive or folder?

The DELETE statement may fail if it violates a trigger or tries to remove a row referenced by data in another table with a FOREIGN KEY constraint. Check one of...