This was the article http://www.sqlservercentral.com/articles/Development/2945/ that I'd read about dynamic connection string.

Jeff, can I please use your saying "..we should all carry forward: share the knowledge we’ve all fought so hard to learn." ? We can only learn when...

Thank you everyone for your help and suggestion. Production issue over the last few days and now finally have time to concentrate on this. I will try the...

Thank you everyone for your help and suggestion. Production issue over the last few days and now finally have time to concentrate on this. I will try the...

Yes I agree that some of the question posted - you can get the answer from BOL or from other posts, but on the other hand I can understand the...

Thank you Sarabpreet for your response. However, I'm on SQL2000.

Also, I found a way to get the logical and physical name for the database file and the logfile.

use dbname

sp_helpfile...

Thank you Sarabpreet for your response. However, I'm on SQL2000.

Also, I found a way to get the logical and physical name for the database file and the logfile.

use dbname

sp_helpfile...

Thank you Sarabpreet for your response. However, I'm on SQL2000.

Also, I found a way to get the logical and physical name for the database file and the logfile.

use dbname

sp_helpfile...

Codezilla, have you find a solution to your restore script yet ? I'm also looking for a script to restore 10 databases that I can run whenever needed. ...

Sorry everyone, I was not able to work on this yesterday.

I ran it as myself (admin right on both servers) and had the same problem as I ran it as...

rename the backup file still give me the same error. The only thing that worked is choosing the 3rd option (database restored and initialized). I had not try...

Sorry everyone, I did not notice the second page.

Here is my result from the Exec command:

Volume in drive \\datadev01\d$ has no label.

Volume Serial Number is FC25-601B

NULL

Directory of...

Sorry George,

I click the post too quickly. The error I got when I ran the job is:

Cannot open backup device '\\datadev01\d$\DBA\Thitesting\DBA.bak'. Operating system error 2(The system cannot find the...

Cannot open backup device '\\datadev01\d$\DBA\Thitesting\DBA.bak'. Operating system error 2(The system cannot find the file specified.).

RESTORE FILELIST is terminating abnormally. (Microsoft SQL Server, Error: 3201)

Hi George,

I know that would be the easiest solution, but I would like to know why it does not work, when it said it would.