Run the following code, putting the output to a .txt file and upload that file here.

RESTORE FILELISTONLY FROM DISK = 'C:\SASE\DatabaseOldBackup\SASE041202'

vrabhadram (4/6/2009)

---

Is the SQL I have written:

i have only the backup of this databse. at present we dont have that server.

RESTORE DATABASE SASE

FROM DISK = 'C:\SASE\DatabaseOldBackup\SASE041202'

WITH REPLACE, MOVE 'SASE_log2' TO...

If you remember, I also asked you for the logical and physical files names. To assist further, I will need this information from both servers for this database.

Simple answer, the server you are attempting the restore on is not configured the same as the server from which you are attempting a restore.

Since they are not the same,...

I'm not really sure what you mean by...

All further replies should be directed here.

As I stated in your other thread, I also need the code you are using for the restore. Let us use this one thread for this problem instead of...

Then we have a user having a problem with a restore, and they post this and this instead of what the real problem is.

Well, we just got a call tonight, my wife's aunt died today. Apparently there won't be a funeral, so not sure what is going on there. Hit my...

Well then, wouldn't it be better to actually post what the problem is rather than post other questions that may or may not actually help? Please provide as much...

You need to read the RESTORE DATABASE command in Books Online. Specifically, you need to read about the MOVE clause. If, after reading, you still have questions come...

First question, have you read the information regarding these clauses in Books Online (BOL)? If so, can you explain a little more as to what is confusing you regarding...

This is PeopleSoft. If the code is generated/maintained by the PeopleSoft tools, the poster unfortunately has little control over how the code is generated.

I'll pass this thread on to...

cchart3 (4/6/2009)

---

I built a simple procedure below to learn more tsql. The output of the print statement produces the correct output. I can take the output of the print...

The Thread started as a rant about the state of questions posted by some people. But I think it morphed over time. Yes, we still go there to...