Absolutely, you can apply SP 3 directly to your current setup. Generally Microsoft rolls all SP's, updates, patches and etc. into a cumulative package.

By far a full backup of...

Is this a new maintenance plan or one that worked and now fails? If the later of the two, has there been any issues with the DNS server?

You may...

In SSMS, expand server | expand Security | expand Logins | right-click on user ID | User Mapping

Hope this helps.

Is the server computer in a workgroup and not part of a domain?

Was there any version of SQL Server ever installed on this particular machine before?

What OS are you working with?

Can you please post the results to the following:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Do you possibly mean Index Fragmentation?

Best practice is to install SP3, then update 4062. This is especially true as 4062 is NOT a Cumulative update.

http://www.microsoft.com/technet/security/bulletin/MS09-062.mspx

Like everything that has to do with SQL and configuration, the answer depends.

If you have a large database, say 10GB, then adding 10% growth would consume an additional 1GB of...

Developer edition is even better. If you can find that copy - perfect.

Good luck with the upgrade.

C

Unfortunately you cannot do a direct upgrade from SQL 7 to SQL 2008, please review the following article for acceptable upgrade versions.

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

One option would be to do a side by...

Last question on the subject, as all of the information you have provided is extremely helpful, when our development team has a "once in a blue moon" bulk insert (which...

Thank you Gail -

Will the .ldf return to the initial size of 2MB after all transaction have completed?

I believe what you are looking for is DB2OLEDB Provider - please review this link for a download. This download is only good for Enterprise and Developer Editions

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en

Why not create a seperate Maintenance Plan for each Db?