Where can backup files be saved? What native tools does SQL Server provide for creating backups? How would you access those tools? How would you retrieve the...

Wow. I am so learning a lot from this thread. I thought I knew details about our SAN. Until I looked at the chart and realized the...

There is a time limit, but if you know your way around, this isn't an issue.

The questions aren't terribly complicated. You don't have to do 50 things before the...

There are a couple of ways you can do it.

A) Write a script task (C# .Net or VB .Net) on SSIS and run that job on a scheduled...

The PBT for exam 431 is totally SSMS based. Essentially, you need to open up Management Studio, going through the Object Explorer bit by bit and figure out how...

You're welcome.

Let us know if you have any other questions.

Sounds like a plan. @=)

You can pretty much start anywhere. Here's a link to all the SQL Server certs: http://www.microsoft.com/learning/mcp/mcitp/default.mspx

Only three of the certs on that page are relevant to SQL Server....

You should at least know the syntax to the basic commands and some of the newer stuff. There are multiple choice questions which ask you about syntax and what...

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!