Odd. In so far as I know, the install of Visual Studio does not automatically install SQL Express. It certainly didn't on mine.

Anyone else see this behavior?

When SQL 2k5 installs, it goes through a list to check components. Did you see any errors or warnings from that part of the install?

Have you tried the BackupDeviceList object yet?

http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.aspx

Actually, how far have you gotten in your coding? Do you already have the connections set up? Or are you starting from scratch right now?

Given 3rd party tools like Litespeed can do P.I.T. restores and they do it by accessing Microsoft .dlls, I would think that you can do it.

I'm not sure...

Thanks for the info! I appreciate it!

The way I learn is to not only take notes of keypoints while I'm studying, but to have 2005 set up on a test server where I can try the...

Dan,

How are you backing up? T-SQL or with a maintenance plan? Or are you using a third party tool?

Where are you backing up? Tape Drive, disk drive,...

Stupid question, but when you upgraded your software, did you upgrade your hardware too?

I've noticed on some boxes that if the hardware remains at 2000 levels, that 2005 can run...

It's a sad truth that it doesn't matter if your users are athenticated or not. Don't go the 5 seat route. If you get caught, you could get...

I hate to break it to you, dr_csharp, but all SQL Server 2005 have some limitations on what OS they will use. At minimum, any Windows 2000 OS has...

We actually have a T-SQL script which uses XPCmdShell to read a list of the backup files from a specific directory. Then we parse the name down to pull...

If you back up to disk, a rather simplistic way to do this is to use C# script to list the files in a specific directory that end with your...

One thing to consider on the SalesTable error is the schema name. Is the default name dbo? If not, you might have to edit whatever query is referencing...

We get similar error messages at random during the day. We're currently troubleshooting, but our best guess right now is network error. Also, we've gotten that error when...