SMO.Restore Database name change

Restore failed for Server 'SERVER1'.

"Tom Moreau" wrote in message

> What error message are you getting?
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>
> "Landry, Eric" wrote in message
>
> I am restoring a database with SQL-SMO. Is there a way to restore to a
> database with a differant name. For example, I have a backup of a
> database
> called "DB1". I want to restore that database as "DB2". Bellow is the
> code
> that I am using now.
>
>
> Dim svr As Server = New Server("SERVER1")
> Dim res As Restore = New Restore()
>
>
> res.Devices.AddDevice("C:\Development\Projects\SQLAutoRestore\BackupFiles\db
> 01.bak",
> DeviceType.File)
> res.Database = "DB2"
> res.NoRecovery = False
> res.ReplaceDatabase = True
> res.SqlRestore(svr)
>
>
>
 >> Stay informed about: SMO.Restore Database name change 

Perhaps if you use Profiler to catch the RESTORE command submitted by SMO, and we can work our
backwards by seeing that command?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Landry, Eric" wrote in message

> Restore failed for Server 'SERVER1'.
>
> "Tom Moreau" wrote in message
>
>> What error message are you getting?
>>
>> --
>> Tom
>>
>> ----------------------------------------------------
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>>
>> "Landry, Eric" wrote in message
>>
>> I am restoring a database with SQL-SMO. Is there a way to restore to a
>> database with a differant name. For example, I have a backup of a database
>> called "DB1". I want to restore that database as "DB2". Bellow is the code
>> that I am using now.
>>
>>
>> Dim svr As Server = New Server("SERVER1")
>> Dim res As Restore = New Restore()
>>
>>
>> res.Devices.AddDevice("C:\Development\Projects\SQLAutoRestore\BackupFiles\db
>> 01.bak",
>> DeviceType.File)
>> res.Database = "DB2"
>> res.NoRecovery = False
>> res.ReplaceDatabase = True
>> res.SqlRestore(svr)
>>
>>
>>
>
 >> Stay informed about: SMO.Restore Database name change 

Thanks for the profiler idea. My backup was trying to overwrite the
original database files. I needed use a with move statement.


res.Devices.AddDevice(DevicePath, DeviceType.File)

Dim DataFile As New RelocateFile
Dim MDF As String = res.ReadFileList(svr).Rows(0)(1)
DataFile.LogicalFileName = res.ReadFileList(svr).Rows(0)(0)
DataFile.PhysicalFileName = Path.Combine(Path.GetDirectoryName(MDF),
DatabaseName & Path.GetExtension(MDF))

Dim LogFile As New RelocateFile
Dim LDF As String = res.ReadFileList(svr).Rows(1)(1)
LogFile.LogicalFileName = res.ReadFileList(svr).Rows(1)(0)
LogFile.PhysicalFileName = Path.Combine(Path.GetDirectoryName(LDF),
DatabaseName & Path.GetExtension(LDF))

res.RelocateFiles.Add(DataFile)
res.RelocateFiles.Add(LogFile)

res.Database = DatabaseName
res.NoRecovery = NoRecovery
res.ReplaceDatabase = True
res.SqlRestore(Server)


Thanks again.


"Tibor Karaszi" wrote in
message
> Perhaps if you use Profiler to catch the RESTORE command submitted by SMO,
> and we can work our backwards by seeing that command?
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
> "Landry, Eric" wrote in message
>
>> Restore failed for Server 'SERVER1'.
>>
>> "Tom Moreau" wrote in message
>>
>>> What error message are you getting?
>>>
>>> --
>>> Tom
>>>
>>> ----------------------------------------------------
>>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>>> SQL Server MVP
>>> Toronto, ON Canada
>>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>>
>>>
>>> "Landry, Eric" wrote in message
>>>
>>> I am restoring a database with SQL-SMO. Is there a way to restore to a
>>> database with a differant name. For example, I have a backup of a
>>> database
>>> called "DB1". I want to restore that database as "DB2". Bellow is the
>>> code
>>> that I am using now.
>>>
>>>
>>> Dim svr As Server = New Server("SERVER1")
>>> Dim res As Restore = New Restore()
>>>
>>>
>>> res.Devices.AddDevice("C:\Development\Projects\SQLAutoRestore\BackupFiles\db
>>> 01.bak",
>>> DeviceType.File)
>>> res.Database = "DB2"
>>> res.NoRecovery = False
>>> res.ReplaceDatabase = True
>>> res.SqlRestore(svr)
>>>
>>>
>>>
>>
>
 >> Stay informed about: SMO.Restore Database name change 

Glad you found a solution. I frequently use Profiler whenever I use some API that "does something
strange".

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Landry, Eric" wrote in message

> Thanks for the profiler idea. My backup was trying to overwrite the original database files. I
> needed use a with move statement.
>
>
> res.Devices.AddDevice(DevicePath, DeviceType.File)
>
> Dim DataFile As New RelocateFile
> Dim MDF As String = res.ReadFileList(svr).Rows(0)(1)
> DataFile.LogicalFileName = res.ReadFileList(svr).Rows(0)(0)
> DataFile.PhysicalFileName = Path.Combine(Path.GetDirectoryName(MDF), DatabaseName &
> Path.GetExtension(MDF))
>
> Dim LogFile As New RelocateFile
> Dim LDF As String = res.ReadFileList(svr).Rows(1)(1)
> LogFile.LogicalFileName = res.ReadFileList(svr).Rows(1)(0)
> LogFile.PhysicalFileName = Path.Combine(Path.GetDirectoryName(LDF), DatabaseName &
> Path.GetExtension(LDF))
>
> res.RelocateFiles.Add(DataFile)
> res.RelocateFiles.Add(LogFile)
>
> res.Database = DatabaseName
> res.NoRecovery = NoRecovery
> res.ReplaceDatabase = True
> res.SqlRestore(Server)
>
>
> Thanks again.
>
>
> "Tibor Karaszi" wrote in message
>
>> Perhaps if you use Profiler to catch the RESTORE command submitted by SMO, and we can work our
>> backwards by seeing that command?
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>>
>> "Landry, Eric" wrote in message
>>
>>> Restore failed for Server 'SERVER1'.
>>>
>>> "Tom Moreau" wrote in message
>>>
>>>> What error message are you getting?
>>>>
>>>> --
>>>> Tom
>>>>
>>>> ----------------------------------------------------
>>>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>>>> SQL Server MVP
>>>> Toronto, ON Canada
>>>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>>>
>>>>
>>>> "Landry, Eric" wrote in message
>>>>
>>>> I am restoring a database with SQL-SMO. Is there a way to restore to a
>>>> database with a differant name. For example, I have a backup of a database
>>>> called "DB1". I want to restore that database as "DB2". Bellow is the code
>>>> that I am using now.
>>>>
>>>>
>>>> Dim svr As Server = New Server("SERVER1")
>>>> Dim res As Restore = New Restore()
>>>>
>>>>
>>>> res.Devices.AddDevice("C:\Development\Projects\SQLAutoRestore\BackupFiles\db
>>>> 01.bak",
>>>> DeviceType.File)
>>>> res.Database = "DB2"
>>>> res.NoRecovery = False
>>>> res.ReplaceDatabase = True
>>>> res.SqlRestore(svr)
>>>>
>>>>
>>>>
>>>
>>
>
 >> Stay informed about: SMO.Restore Database name change 

Hello,

I have created backup of the database programatically. The Database is DB1 and it is on server SER1.
The backup file is sitting on C:\.... on SER1.
Now I want to restore this backup file on another server SER2 with same name or different name.
Any ideas about this?
I do not have any common fileshare location where I can move .bak file from SER1 at present.
Thank you very much !

-Rashmi

> On Wednesday, May 14, 2008 1:22 PM Landry, Eric wrote:

> I am restoring a database with SQL-SMO. Is there a way to restore to a
> database with a differant name. For example, I have a backup of a database
> called "DB1". I want to restore that database as "DB2". Bellow is the code
> that I am using now.
>
>
> Dim svr As Server = New Server("SERVER1")
> Dim res As Restore = New Restore()
>
> res.Devices.AddDevice("C:\Development\Projects\SQLAutoRestore\BackupFiles\db01.bak",
> DeviceType.File)
> res.Database = "DB2"
> res.NoRecovery = False
> res.ReplaceDatabase = True
> res.SqlRestore(svr)


>> On Wednesday, May 14, 2008 1:46 PM Tom Moreau wrote:

>> What error message are you getting?
>>
>> --
>> Tom
>>
>> ----------------------------------------------------
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>>
>> "Landry, Eric" wrote in message
>>
>> I am restoring a database with SQL-SMO. Is there a way to restore to a
>> database with a differant name. For example, I have a backup of a database
>> called "DB1". I want to restore that database as "DB2". Bellow is the code
>> that I am using now.
>>
>>
>> Dim svr As Server = New Server("SERVER1")
>> Dim res As Restore = New Restore()
>>
>>
>> res.Devices.AddDevice("C:\Development\Projects\SQLAutoRestore\BackupFiles\db
>> 01.bak",
>> DeviceType.File)
>> res.Database = "DB2"
>> res.NoRecovery = False
>> res.ReplaceDatabase = True
>> res.SqlRestore(svr)


>>> On Wednesday, May 14, 2008 2:46 PM Landry, Eric wrote:

>>> Restore failed for Server 'SERVER1'.


>>>> On Wednesday, May 14, 2008 2:59 PM Tibor Karaszi wrote:

>>>> Perhaps if you use Profiler to catch the RESTORE command submitted by SMO, and we can work our
>>>> backwards by seeing that command?
>>>>
>>>> --
>>>> Tibor Karaszi, SQL Server MVP
>>>> http://www.karaszi.com/sqlserver/default.asp
>>>> http://sqlblog.com/blogs/tibor_karaszi
>>>>
>>>>
>>>> "Landry, Eric" wrote in message
>>>>


>>>>> On Wednesday, May 14, 2008 5:50 PM Landry, Eric wrote:

>>>>> Thanks for the profiler idea. My backup was trying to overwrite the
>>>>> original database files. I needed use a with move statement.
>>>>>
>>>>>
>>>>> res.Devices.AddDevice(DevicePath, DeviceType.File)
>>>>>
>>>>> Dim DataFile As New RelocateFile
>>>>> Dim MDF As String = res.ReadFileList(svr).Rows(0)(1)
>>>>> DataFile.LogicalFileName = res.ReadFileList(svr).Rows(0)(0)
>>>>> DataFile.PhysicalFileName = Path.Combine(Path.GetDirectoryName(MDF),
>>>>> DatabaseName & Path.GetExtension(MDF))
>>>>>
>>>>> Dim LogFile As New RelocateFile
>>>>> Dim LDF As String = res.ReadFileList(svr).Rows(1)(1)
>>>>> LogFile.LogicalFileName = res.ReadFileList(svr).Rows(1)(0)
>>>>> LogFile.PhysicalFileName = Path.Combine(Path.GetDirectoryName(LDF),
>>>>> DatabaseName & Path.GetExtension(LDF))
>>>>>
>>>>> res.RelocateFiles.Add(DataFile)
>>>>> res.RelocateFiles.Add(LogFile)
>>>>>
>>>>> res.Database = DatabaseName
>>>>> res.NoRecovery = NoRecovery
>>>>> res.ReplaceDatabase = True
>>>>> res.SqlRestore(Server)
>>>>>
>>>>>
>>>>> Thanks again.
>>>>>
>>>>>
>>>>> "Tibor Karaszi" wrote in
>>>>> message


>>>>>> On Thursday, May 15, 2008 3:28 AM Tibor Karaszi wrote:

>>>>>> Glad you found a solution. I frequently use Profiler whenever I use some API that "does something
>>>>>> strange".
>>>>>>
>>>>>> --
>>>>>> Tibor Karaszi, SQL Server MVP
>>>>>> http://www.karaszi.com/sqlserver/default.asp
>>>>>> http://sqlblog.com/blogs/tibor_karaszi
>>>>>>
>>>>>>
>>>>>> "Landry, Eric" wrote in message
>>>>>>


>>>>>> Submitted via EggHeadCafe - Software Developer Portal of Choice
>>>>>> Lucene.Net Indexing Searching Entry Level Tutorial
>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/c69ef65f-e3c6-409e-ab97-16...7c74f83
 >> Stay informed about: SMO.Restore Database name change