Prev: Questions regarding Data center operation
Next: Logical proof of SQL change - HELP please!
From: Pedro Juan on 27 Jul 2010 08:01
I made a backup with sqlserver 2000 and then perform a restore on
SQLServer2005 and all right but once done all this I can not change anything.
Why?

why can not change anyting on the resoresd database ?


Thanks and kind Regards.

From: Dan on 27 Jul 2010 10:24

"Pedro Juan" <PedroJuan(a)discussions.microsoft.com> wrote in message
news:936E8DF6-01B1-4802-A632-B9E7A9ED7626(a)microsoft.com...
> I made a backup with sqlserver 2000 and then perform a restore on
> SQLServer2005 and all right but once done all this I can not change
> anything.
> Why?
>
> why can not change anyting on the resoresd database ?
>
>
> Thanks and kind Regards.
>

What do you mean by "cannot change anything"? Did you restore with the
option to leave the database in the recovery state? This would leave it
unusable until restoring a log file, for instance, to stop anyone using it
while a backup chain is being restored.

If you are trying to use SQL Server 2005 features (those that are not
available in SQL Server 2000) then you will first need to change the
compatibility mode on the database to the latest level, when a database is
restored from an older version of SQL Server the mode is deliberately set to
only support those features from the older database engine version in order
to try to preserve backwards compatibility with applications using the
database.

--
Dan

From: Nico on 28 Jul 2010 07:23

ok thanks for your help , but i have change compatiblity level to 90. but
i try changed the propierties of user dbo said me :

Exception , error 15405.

dont let me change anything in the database sql server 2005.


"Dan" wrote:

>
> "Pedro Juan" <PedroJuan(a)discussions.microsoft.com> wrote in message
> news:936E8DF6-01B1-4802-A632-B9E7A9ED7626(a)microsoft.com...
> > I made a backup with sqlserver 2000 and then perform a restore on
> > SQLServer2005 and all right but once done all this I can not change
> > anything.
> > Why?
> >
> > why can not change anyting on the resoresd database ?
> >
> >
> > Thanks and kind Regards.
> >
>
> What do you mean by "cannot change anything"? Did you restore with the
> option to leave the database in the recovery state? This would leave it
> unusable until restoring a log file, for instance, to stop anyone using it
> while a backup chain is being restored.
>
> If you are trying to use SQL Server 2005 features (those that are not
> available in SQL Server 2000) then you will first need to change the
> compatibility mode on the database to the latest level, when a database is
> restored from an older version of SQL Server the mode is deliberately set to
> only support those features from the older database engine version in order
> to try to preserve backwards compatibility with applications using the
> database.
>
> --
> Dan
>
> .
>
From: Dan on 28 Jul 2010 12:14
Have you used sp_change_login to fix any orphaned users?

That error is also expected if you are logged in as the sysadmin user, as
dbo cannot be assigned to any role membership. What are you trying to
change?

Dan


"Nico" <Nico(a)discussions.microsoft.com> wrote in message
news:7DF5C690-6470-49B4-BEB3-84B3A39C9359(a)microsoft.com...
>
> ok thanks for your help , but i have change compatiblity level to 90. but
> i try changed the propierties of user dbo said me :
>
> Exception , error 15405.
>
> dont let me change anything in the database sql server 2005.
>
>
> "Dan" wrote:
>
>>
>> "Pedro Juan" <PedroJuan(a)discussions.microsoft.com> wrote in message
>> news:936E8DF6-01B1-4802-A632-B9E7A9ED7626(a)microsoft.com...
>> > I made a backup with sqlserver 2000 and then perform a restore on
>> > SQLServer2005 and all right but once done all this I can not change
>> > anything.
>> > Why?
>> >
>> > why can not change anyting on the resoresd database ?
>> >
>> >
>> > Thanks and kind Regards.
>> >
>>
>> What do you mean by "cannot change anything"? Did you restore with the
>> option to leave the database in the recovery state? This would leave it
>> unusable until restoring a log file, for instance, to stop anyone using
>> it
>> while a backup chain is being restored.
>>
>> If you are trying to use SQL Server 2005 features (those that are not
>> available in SQL Server 2000) then you will first need to change the
>> compatibility mode on the database to the latest level, when a database
>> is
>> restored from an older version of SQL Server the mode is deliberately set
>> to
>> only support those features from the older database engine version in
>> order
>> to try to preserve backwards compatibility with applications using the
>> database.
>>
>> --
>> Dan
>>
>> .
>>



From: Erland Sommarskog on 28 Jul 2010 17:59
Nico (Nico(a)discussions.microsoft.com) writes:
> ok thanks for your help , but i have change compatiblity level to 90.
> but
> i try changed the propierties of user dbo said me :
>
> Exception , error 15405.
>
> dont let me change anything in the database sql server 2005.

If you restored the database from another server, dbo may not map to a login
on the new server. Use

ALTER AUTHORIZATION ON DATABASE::db TO newowner

to fix this.


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 |  Next  |  Last
Pages: 1 2 3
Prev: Questions regarding Data center operation
Next: Logical proof of SQL change - HELP please!