Monday, February 20, 2012

migrating to 2005 troubles :(

hey guys
just to do a test run i wanted to migrate the northwind database from
2000 to 2005
when i do a backup and try to restore on the new machine ... i receive
this message
i know its probably something trivial ... but can anyone give me a
hand with this ?
TITLE: Microsoft SQL Server Management Studio
--
Restore failed for Server 'NAMECLapps\ins1'.
(Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: Cannot use file 'C:\test\northwnd.mdf'
for clustered server. Only formatted files on which the cluster
resource of the server has a dependency can be used.
(Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?Prod...00&LinkId=20476You can't put a user db on the local drive of a cluster. It must be one of
the drives in the cluster resource group.
Andrew J. Kelly SQL MVP
<glombica@.hotmail.com> wrote in message
news:1185286074.533480.16750@.m3g2000hsh.googlegroups.com...
> hey guys
> just to do a test run i wanted to migrate the northwind database from
> 2000 to 2005
> when i do a backup and try to restore on the new machine ... i receive
> this message
> i know its probably something trivial ... but can anyone give me a
> hand with this ?
>
> TITLE: Microsoft SQL Server Management Studio
> --
> Restore failed for Server 'NAMECLapps\ins1'.
> (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> System.Data.SqlClient.SqlError: Cannot use file 'C:\test\northwnd.mdf'
> for clustered server. Only formatted files on which the cluster
> resource of the server has a dependency can be used.
> (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...
0&LinkId=20476
>

No comments:

Post a Comment