Just went through migrating to SQL 2005, and maybe this info will help:

We use third party backup tools (a la SQL LiteSpeed) to perform log shipping, but the process is...

The best recovery model to use is different for each scenario. Basically, if there are very few users, and therefore very little transactions, you probably would be best switching to...

Ok, that's good to know.

You said that the database is being backed up daily; so there's one full backup of the database happening every 24 hours or so, correct? No...

Thanks for the info. One thing; when I referred to the recovery model, I meant the setting for the database. On SQL 2005, there's a few ways to check:

1. sp_helpdb...

Hi Dipendra,

Is your database being backed up regularly? Also, what is the recovery model for the database? Its probably a better idea to get a handle on why the transaction...

The Upgrade Advisor will catch any code in stored procedures, views, etc. as well as any functional dependencies on deprecated components or changed components. If you also specify trace files...

Using LocalSystem won't work in a distributed environment. In order for the services on the different servers to "see" each other, you'll need a method of authenticating across server, i.e....

My apologies; I misunderstood.

I see the problem now. I can't get that to work either. Look forward to seeing if anyone else can.

In the External Tools dialog box:

Title: Explore

Command: C:\Windows\explorer.exe

Arguments: \\server\path

Initial Directory: [blank]

I pointed the arguments at our backup server, and now when I click on Tools>Explore, I get an explorer...

The other thing that causes this is simply opening up the server properties dialog in Enterprise Manager and clicking OK to exit instead of Cancel (i.e. a DBA goes to...

Don't know if this will help, but:

When we experienced 17883 errors, it tracked back to a known issue with BULK_INSERTS and high-end disk subsystems. The fix is NOT included in...

Did you run the Advisor using a trace file or SQL scripts? That's probably the best bet to catch outdated code.

There's also some documentation in the Upgrade Advisor's Help...

A little more info would help (what are the service accounts, etc.), but here is a thought:

Does the account that SQL Agent runs on have access to that server? Since...

In SSMS, click Tools (at the top), then External Tools. You can add commands with parameters (I even did exactly what you described, just to make sure it works).

Hi Bill,

When you say the developers are DBO's, do you mean that the database owner is actually mapped to a developer login (as in, when right clicking on the properties...