I did a little more reading, Jeff. As...

Steve Jones - Editor (4/7/2009)

---

The MVP certainly isn't a ton of knowledge. It's a community contribution award.

Arguably I haven't contributed anything substantial to the SQL knowledge base in quite some...

Using SELECT * is just lazy. Do all the queries that are being run need all the columns from all the rows everytime? that is the question I'd...

Actually, depending on what and how they are doing things, there are "ways" around the tools. ...

Yes. I provide SQL Server support for our PeopleSoft developers, so I have learned a bit...

Jeff Moden (4/7/2009)

---

Jeff Moden (4/6/2009)

---

Lynn Pettis (4/5/2009)

---

Well said, both the editorial and the pod cast. From that, I really think that my blog posts are particularly relevant. For...

Solution to what? You haven't provided us with enough information do help you yet. Have you read...

Looks to me like that may be a third party or in-house routine. I'm not familiar with it and a search of the web on Google and Yahoo don't...

Not really sure, you haven't told us much. Are you getting an error of some sort? If so, what is the error you are receiving? That would...

I appreciate the sentiment,...

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...