February 12, 2009 at 6:43 pm
I have database with 48 partitions (48 ndf,1 mdf,1 ldf) for 4 years data. I took a backup of that database to restore on to another server. I cheked for restore filelistonly but it gives me bad backup media error.
How could i restore the backup onto differnt drive with the same partiotions using master.dbo.xp_restore_database
February 12, 2009 at 6:46 pm
No SQL Lite speed?
February 12, 2009 at 7:16 pm
yes i have sql litespeed
February 12, 2009 at 7:47 pm
Command to restore database through sqllitespeed.
exec xp_restore_database @database = ,
@filename = 'BkpFile with location',
@with ='move "LogicalFileName" to "OSFileLocation"',
@with = 'move"LogicalFileName" to "OSFileLocaton"',
,
.................................. ,
@with ='recovery'
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply