Thanks so much for posting this (even though it was a long time ago!) I've been searching for a solution to getting the date created for a file all...

As an additional aspect of the upgrade question, there has been some debate in our office as to whether it would be more beneficial to continue on the SP2 path,...

Thanks for the xp_cmdshell tip. I've looked at this and believe this command could provide a good solution.

I am finding quite a lot of information related to deleting files,...

Thanks for replying, Pablo.

Is there a way to extract the file creation date so I can condition the move based on the date the file was created? We don't...

Please disregard! I figured it out.

I used the following script to initiate a manual failover:

USE master;

Issued the following statement on the principal server:

ALTER DATABASE database_name SET PARTNER...

Thanks very much for your response. Based on that, the setting should have no consequences in our current mirroring configuration and I will leave it as is.

I visited the...

This issue has been resolved.

For the benefit of others who may encounter the same issue, these are the steps that lead to a successful reconfigure of our mirrored database:

Servers involved...

Thanks for the response, Bob. I'll tweak the script and see if I can pull out the information we need. I appreciate your help.

Kay

The DBCC CHECKDB resulted in 0 errors, so apparently the error didn't impact the database or the indicated table. Thanks for the link; I'll bookmark it for future reference.

Just...

Thanks very much for the response. We are getting authorization to run this command.

Once run, I presume based on the information returned by the command we will have to...

Well I think what we're trying to do is the impossible, and we'll have to simply restore the database to the beginning of the critical test. It was a...

Is it possible to apply a transaction log that is outside the regular backup set?

We are in the process of rebuilding our database to a "year end" state. If...

Thank you very much for responding.

Here are the sequence of events:

4/18 9:00 pm A full backup was taken of the Db

4/20 3:00 am The database was restored from...

I need to revise this request a bit.

We do have a full backup from a database outside the backup set that represents our starting point (the database we're trying to...

Only in the sense that I'm in Management Studio, and right-click on the database to select the backup task to back up the tail of the transaction log.