Try this:-

RESTORE FILELISTONLY

FROM DISK = 'E:\xyz.bak' /*this shld be location of ur bak file*/

GO

whatever result you get from above statement in that...the logical file name(mdf and ldf...

@ ashish

I did that too..

no difference...

I today deleted the last 2 days backup manually.

Regards,

Sushant

@ above all

Restoring completed successfully.

I ran the restore script from SSMS inside the RDP.

earlier i was doing from outside.

Thanks all for your valuable suggestions

Regards,

Sushant

@ steve

But whenever i visit a different post on any forums, my visit increases by 1 each time and so if i reply to that also, i will get 1...

@ steve

Okk, and u r a perfect example for that....lol

Regards,

Sushant

@ pradeep

Thxs a lot !!

Regards,

Sushant

the maximum ratio of points to visits should be 1

and generally it should be less than 1

Regards,

Sushant

@ gilamonster

Is that option added manually or if not

How can i check for that.

Regards,

Sushant

@ steve,

Ya, thats wat i read too

but some people say that the "If you're using a newer version of sql server (patch or service pack included) there are...

I RAN:--

RESTORE DATABASE XYZ

FROM DISK = 'E:\xyz_backup_201009022015.bak'

WITH MOVE 'logical_name.mdf' TO 'E:\SQLDatabases\XYZ.mdf',

MOVE 'logical_name.ldf' TO 'E:\SQLLogs\XYZ.ldf',

STATS=5

I recevied error:-

Msg 64, Level 20, State 0, Line 0

A transport-level error has occurred when receiving results...

@ cory

Got it.

Thanks a lot.

Regards,

Sushant

@cory

I couldnt get you?

Where should i write the tsql?

theres no option when i go thru data, external data source,sql server

it just asks for selecting the table and then it...

@ lowell

Ya, tht script runs successfully, but theres no output

I mean i ran against the database, what should i get as output??

i just got query successful...

Thanks,

Regards,

Sushant

@ lowell

I tried to run the script in the database

but i got many errors like invalid name like sysproperties...

Do u hav any idea about tht?

Thanks.

Regards,

Sushant

@ cory

Ya, If we go to data

then external data sources , we can get data from sql

but that data we get is inside the tables, i mean the columns, theier...