A couple of things to check:

1) Did you perform a full backup, or was it a transaction log or differential backup? Either of those will be a lot smaller...

Jeff Moden (8/6/2009)

---

GilaMonster (8/6/2009)

---

It was a feature added in SQL 2005 for cases where an index needs to be dropped for data loads. It means that the index can be...

Let's say you have the following tasks in your maintenance plan:

Check Database Integrity

Backup Databases

Maintenance Cleanup

And now, let's say that normally the integrity check takes 1 minute and the backup takes...

Ewan Hampson (8/6/2009)

---

There was a bug until an SP2 hotfix. But it should be...

If you are using the standard maintenance cleanup task - this can happen because it works based upon the time the task runs. If the time frame you are...

I just ran through several tests executing that stored procedure. The only time I had any problems with it deleting files is when I had an extra space at...

You should also validate...

Melton (8/5/2009)

---

Does the backup exist within the backup history in SQL?

I have been looking around to try to find this on Google, and if someone can point me to...

Not sure what to tell you, I am using that procedure for versions from 2005 SP2 on up through 2008 with no problems.

If you are not getting any errors and...

Modify the plan and remove the extra space at the end. If that doesn't...

This is where I would start when setting up log shipping: http://msdn.microsoft.com/en-us/library/ms188698(SQL.90).aspx

Since I do not use it and instead have setup database mirroring - I really cannot say for sure....

mahesh.vsp (8/4/2009)

---

Hi Jeff,

Even i got the same question in my mind. SQL Server Server Edition can only be installed on OS Server. but i have seen the scenario in an...

No - it is not supported, even if you could get it to install. Why do you want to install on a desktop?

If you are already licensed for Enterprise Edition on that server - you can install as many instances as you want running Enterprise Edition. There is no additional cost...

Yes you could - but you don't need to. Here is what I would do:

1) Shrink the current log file to an acceptable small size, say 100MB.

2) Detach the...