You have to rstore the full backup with norecovery so you can apply the logs.

Have you considered log shipping? Are you planning on using the copy on the RS...

Thanks Lowell, that's one I've never heard of. We'll be bringing in the suggested replacements for testing. So far we have SQL Visualizer and SQL Workbench as suggestions,...

I don't think it's possible. In order to go backward, you'll need to copy objects and data out of 2008 and back in to 2005. The 2005 server...

There have been countless examples on these forums of cases where OPs expected data to be returned in clustered index order when no 'order by' was specified. It's not...

My experience has been that, if it's a date, you should store it as a date. Otherwise, you guarantee additional work to convert it every time you want to...

It helps to have:

Someone who is endlessly curious about the technology

Someone who can speak businessese and not just geek

Someone who is detail oriented

Someone who can understand the context, both business...

I'm not sure, but it probably won't run on Windows because Microsoft isn't going to support a 64 bit driver for the human brain. You won't be able to...

How will you know what the datatype and sizes of the columns are? How will you name the columns? Do you know the number of columns in each...

Yes, Lynn, those date routines are the first blade in my Swiss Army knife of SQL Server tools.

Thank you for your wonderful contributions!

Check to make sure the version of backup exec you're running supports SQL Server 2008. My understanding was that support for 2008 wasn't going to be available until later...

Can you post the table definition and some sample data we could play with?

A cursor-based solution will almost always be the worst way to accomplish anything in SQL Server. The select you used to build the cursor is almost enough to satisfy...

I'm not clear what you want it to do, but the following link has a lot of good utility date calculations and can probably lead you to what you need.

http://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/3/25/some-common-date-routines.aspx

The archive of historical data is accessed in unpredictable ways by the research folks. We'd all like to get it off the OLTP instance.

The new archive server is on...

There are a lot of very good mentors here and most of them, when they have the time, go out of their way to ensure that the solutions they provide,...