When a database is restored Enterprise Manager does not display the users
for the restored database. The account I am signing in with has the correct
rights. I have uninstalled Enterprise Manager and reinstalled with no change.
I notice that when I reinstall Enterprise Manager it immediately displays my
server connections. Which file holds this information and is this file the
likely culprit? Any ideas for solving the issue?
If the dbs were restored from another server, there could be a user/login
mismatch... Users in the db, but no associated login on this server...User
information is stored in each database ( sysusers), and login information is
stored in master.dbo.sysxlogins
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"bassbuster" <bassbuster@.discussions.microsoft.com> wrote in message
news:CC420453-549B-4A58-A75E-FBAA018A1208@.microsoft.com...
> When a database is restored Enterprise Manager does not display the users
> for the restored database. The account I am signing in with has the
> correct
> rights. I have uninstalled Enterprise Manager and reinstalled with no
> change.
> I notice that when I reinstall Enterprise Manager it immediately displays
> my
> server connections. Which file holds this information and is this file the
> likely culprit? Any ideas for solving the issue?
|||Have a look at these, especially the one about mapping logins to users.
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between
Andrew J. Kelly SQL MVP
"bassbuster" <bassbuster@.discussions.microsoft.com> wrote in message
news:CC420453-549B-4A58-A75E-FBAA018A1208@.microsoft.com...
> When a database is restored Enterprise Manager does not display the users
> for the restored database. The account I am signing in with has the
> correct
> rights. I have uninstalled Enterprise Manager and reinstalled with no
> change.
> I notice that when I reinstall Enterprise Manager it immediately displays
> my
> server connections. Which file holds this information and is this file the
> likely culprit? Any ideas for solving the issue?
|||There are two other DB folks that have access to the server and their EM
installs show all of the users as does the EM install on the server itself.
My install is the only one that does not show the users.
"bassbuster" wrote:
> When a database is restored Enterprise Manager does not display the users
> for the restored database. The account I am signing in with has the correct
> rights. I have uninstalled Enterprise Manager and reinstalled with no change.
> I notice that when I reinstall Enterprise Manager it immediately displays my
> server connections. Which file holds this information and is this file the
> likely culprit? Any ideas for solving the issue?
|||Apply SP3a.
Ayad
"bassbuster" <bassbuster@.discussions.microsoft.com> wrote in message
news:BFF0EF1A-F46A-48B1-960E-F3011F007AD3@.microsoft.com...
> There are two other DB folks that have access to the server and their EM
> installs show all of the users as does the EM install on the server
itself.[vbcol=seagreen]
> My install is the only one that does not show the users.
> "bassbuster" wrote:
users[vbcol=seagreen]
correct[vbcol=seagreen]
change.[vbcol=seagreen]
displays my[vbcol=seagreen]
the[vbcol=seagreen]
Showing posts with label restored. Show all posts
Showing posts with label restored. Show all posts
Sunday, March 11, 2012
Enterprise Manager problem
When a database is restored Enterprise Manager does not display the users
for the restored database. The account I am signing in with has the correct
rights. I have uninstalled Enterprise Manager and reinstalled with no change
.
I notice that when I reinstall Enterprise Manager it immediately displays my
server connections. Which file holds this information and is this file the
likely culprit? Any ideas for solving the issue?If the dbs were restored from another server, there could be a user/login
mismatch... Users in the db, but no associated login on this server...User
information is stored in each database ( sysusers), and login information is
stored in master.dbo.sysxlogins
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"bassbuster" <bassbuster@.discussions.microsoft.com> wrote in message
news:CC420453-549B-4A58-A75E-FBAA018A1208@.microsoft.com...
> When a database is restored Enterprise Manager does not display the users
> for the restored database. The account I am signing in with has the
> correct
> rights. I have uninstalled Enterprise Manager and reinstalled with no
> change.
> I notice that when I reinstall Enterprise Manager it immediately displays
> my
> server connections. Which file holds this information and is this file the
> likely culprit? Any ideas for solving the issue?|||Have a look at these, especially the one about mapping logins to users.
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between
Andrew J. Kelly SQL MVP
"bassbuster" <bassbuster@.discussions.microsoft.com> wrote in message
news:CC420453-549B-4A58-A75E-FBAA018A1208@.microsoft.com...
> When a database is restored Enterprise Manager does not display the users
> for the restored database. The account I am signing in with has the
> correct
> rights. I have uninstalled Enterprise Manager and reinstalled with no
> change.
> I notice that when I reinstall Enterprise Manager it immediately displays
> my
> server connections. Which file holds this information and is this file the
> likely culprit? Any ideas for solving the issue?|||There are two other DB folks that have access to the server and their EM
installs show all of the users as does the EM install on the server itself.
My install is the only one that does not show the users.
"bassbuster" wrote:
> When a database is restored Enterprise Manager does not display the users
> for the restored database. The account I am signing in with has the correc
t
> rights. I have uninstalled Enterprise Manager and reinstalled with no chan
ge.
> I notice that when I reinstall Enterprise Manager it immediately displays
my
> server connections. Which file holds this information and is this file the
> likely culprit? Any ideas for solving the issue?|||Apply SP3a.
Ayad
"bassbuster" <bassbuster@.discussions.microsoft.com> wrote in message
news:BFF0EF1A-F46A-48B1-960E-F3011F007AD3@.microsoft.com...
> There are two other DB folks that have access to the server and their EM
> installs show all of the users as does the EM install on the server
itself.[vbcol=seagreen]
> My install is the only one that does not show the users.
> "bassbuster" wrote:
>
users[vbcol=seagreen]
correct[vbcol=seagreen]
change.[vbcol=seagreen]
displays my[vbcol=seagreen]
the[vbcol=seagreen]
for the restored database. The account I am signing in with has the correct
rights. I have uninstalled Enterprise Manager and reinstalled with no change
.
I notice that when I reinstall Enterprise Manager it immediately displays my
server connections. Which file holds this information and is this file the
likely culprit? Any ideas for solving the issue?If the dbs were restored from another server, there could be a user/login
mismatch... Users in the db, but no associated login on this server...User
information is stored in each database ( sysusers), and login information is
stored in master.dbo.sysxlogins
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"bassbuster" <bassbuster@.discussions.microsoft.com> wrote in message
news:CC420453-549B-4A58-A75E-FBAA018A1208@.microsoft.com...
> When a database is restored Enterprise Manager does not display the users
> for the restored database. The account I am signing in with has the
> correct
> rights. I have uninstalled Enterprise Manager and reinstalled with no
> change.
> I notice that when I reinstall Enterprise Manager it immediately displays
> my
> server connections. Which file holds this information and is this file the
> likely culprit? Any ideas for solving the issue?|||Have a look at these, especially the one about mapping logins to users.
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between
Andrew J. Kelly SQL MVP
"bassbuster" <bassbuster@.discussions.microsoft.com> wrote in message
news:CC420453-549B-4A58-A75E-FBAA018A1208@.microsoft.com...
> When a database is restored Enterprise Manager does not display the users
> for the restored database. The account I am signing in with has the
> correct
> rights. I have uninstalled Enterprise Manager and reinstalled with no
> change.
> I notice that when I reinstall Enterprise Manager it immediately displays
> my
> server connections. Which file holds this information and is this file the
> likely culprit? Any ideas for solving the issue?|||There are two other DB folks that have access to the server and their EM
installs show all of the users as does the EM install on the server itself.
My install is the only one that does not show the users.
"bassbuster" wrote:
> When a database is restored Enterprise Manager does not display the users
> for the restored database. The account I am signing in with has the correc
t
> rights. I have uninstalled Enterprise Manager and reinstalled with no chan
ge.
> I notice that when I reinstall Enterprise Manager it immediately displays
my
> server connections. Which file holds this information and is this file the
> likely culprit? Any ideas for solving the issue?|||Apply SP3a.
Ayad
"bassbuster" <bassbuster@.discussions.microsoft.com> wrote in message
news:BFF0EF1A-F46A-48B1-960E-F3011F007AD3@.microsoft.com...
> There are two other DB folks that have access to the server and their EM
> installs show all of the users as does the EM install on the server
itself.[vbcol=seagreen]
> My install is the only one that does not show the users.
> "bassbuster" wrote:
>
users[vbcol=seagreen]
correct[vbcol=seagreen]
change.[vbcol=seagreen]
displays my[vbcol=seagreen]
the[vbcol=seagreen]
Enterprise Manager problem
When a database is restored Enterprise Manager does not display the users
for the restored database. The account I am signing in with has the correct
rights. I have uninstalled Enterprise Manager and reinstalled with no change.
I notice that when I reinstall Enterprise Manager it immediately displays my
server connections. Which file holds this information and is this file the
likely culprit? Any ideas for solving the issue?If the dbs were restored from another server, there could be a user/login
mismatch... Users in the db, but no associated login on this server...User
information is stored in each database ( sysusers), and login information is
stored in master.dbo.sysxlogins
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"bassbuster" <bassbuster@.discussions.microsoft.com> wrote in message
news:CC420453-549B-4A58-A75E-FBAA018A1208@.microsoft.com...
> When a database is restored Enterprise Manager does not display the users
> for the restored database. The account I am signing in with has the
> correct
> rights. I have uninstalled Enterprise Manager and reinstalled with no
> change.
> I notice that when I reinstall Enterprise Manager it immediately displays
> my
> server connections. Which file holds this information and is this file the
> likely culprit? Any ideas for solving the issue?|||Have a look at these, especially the one about mapping logins to users.
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between
--
Andrew J. Kelly SQL MVP
"bassbuster" <bassbuster@.discussions.microsoft.com> wrote in message
news:CC420453-549B-4A58-A75E-FBAA018A1208@.microsoft.com...
> When a database is restored Enterprise Manager does not display the users
> for the restored database. The account I am signing in with has the
> correct
> rights. I have uninstalled Enterprise Manager and reinstalled with no
> change.
> I notice that when I reinstall Enterprise Manager it immediately displays
> my
> server connections. Which file holds this information and is this file the
> likely culprit? Any ideas for solving the issue?|||There are two other DB folks that have access to the server and their EM
installs show all of the users as does the EM install on the server itself.
My install is the only one that does not show the users.
"bassbuster" wrote:
> When a database is restored Enterprise Manager does not display the users
> for the restored database. The account I am signing in with has the correct
> rights. I have uninstalled Enterprise Manager and reinstalled with no change.
> I notice that when I reinstall Enterprise Manager it immediately displays my
> server connections. Which file holds this information and is this file the
> likely culprit? Any ideas for solving the issue?|||Apply SP3a.
Ayad
"bassbuster" <bassbuster@.discussions.microsoft.com> wrote in message
news:BFF0EF1A-F46A-48B1-960E-F3011F007AD3@.microsoft.com...
> There are two other DB folks that have access to the server and their EM
> installs show all of the users as does the EM install on the server
itself.
> My install is the only one that does not show the users.
> "bassbuster" wrote:
> > When a database is restored Enterprise Manager does not display the
users
> > for the restored database. The account I am signing in with has the
correct
> > rights. I have uninstalled Enterprise Manager and reinstalled with no
change.
> > I notice that when I reinstall Enterprise Manager it immediately
displays my
> > server connections. Which file holds this information and is this file
the
> > likely culprit? Any ideas for solving the issue?
for the restored database. The account I am signing in with has the correct
rights. I have uninstalled Enterprise Manager and reinstalled with no change.
I notice that when I reinstall Enterprise Manager it immediately displays my
server connections. Which file holds this information and is this file the
likely culprit? Any ideas for solving the issue?If the dbs were restored from another server, there could be a user/login
mismatch... Users in the db, but no associated login on this server...User
information is stored in each database ( sysusers), and login information is
stored in master.dbo.sysxlogins
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"bassbuster" <bassbuster@.discussions.microsoft.com> wrote in message
news:CC420453-549B-4A58-A75E-FBAA018A1208@.microsoft.com...
> When a database is restored Enterprise Manager does not display the users
> for the restored database. The account I am signing in with has the
> correct
> rights. I have uninstalled Enterprise Manager and reinstalled with no
> change.
> I notice that when I reinstall Enterprise Manager it immediately displays
> my
> server connections. Which file holds this information and is this file the
> likely culprit? Any ideas for solving the issue?|||Have a look at these, especially the one about mapping logins to users.
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between
--
Andrew J. Kelly SQL MVP
"bassbuster" <bassbuster@.discussions.microsoft.com> wrote in message
news:CC420453-549B-4A58-A75E-FBAA018A1208@.microsoft.com...
> When a database is restored Enterprise Manager does not display the users
> for the restored database. The account I am signing in with has the
> correct
> rights. I have uninstalled Enterprise Manager and reinstalled with no
> change.
> I notice that when I reinstall Enterprise Manager it immediately displays
> my
> server connections. Which file holds this information and is this file the
> likely culprit? Any ideas for solving the issue?|||There are two other DB folks that have access to the server and their EM
installs show all of the users as does the EM install on the server itself.
My install is the only one that does not show the users.
"bassbuster" wrote:
> When a database is restored Enterprise Manager does not display the users
> for the restored database. The account I am signing in with has the correct
> rights. I have uninstalled Enterprise Manager and reinstalled with no change.
> I notice that when I reinstall Enterprise Manager it immediately displays my
> server connections. Which file holds this information and is this file the
> likely culprit? Any ideas for solving the issue?|||Apply SP3a.
Ayad
"bassbuster" <bassbuster@.discussions.microsoft.com> wrote in message
news:BFF0EF1A-F46A-48B1-960E-F3011F007AD3@.microsoft.com...
> There are two other DB folks that have access to the server and their EM
> installs show all of the users as does the EM install on the server
itself.
> My install is the only one that does not show the users.
> "bassbuster" wrote:
> > When a database is restored Enterprise Manager does not display the
users
> > for the restored database. The account I am signing in with has the
correct
> > rights. I have uninstalled Enterprise Manager and reinstalled with no
change.
> > I notice that when I reinstall Enterprise Manager it immediately
displays my
> > server connections. Which file holds this information and is this file
the
> > likely culprit? Any ideas for solving the issue?
Friday, March 9, 2012
enterprise manager loading DB
Hello
I have a problem with a loading DB in Enterprise Manager.
I had restored a DB from another Sql Server and something seems wrong. I´ve
got no error message but I have a grey DB Icon with my DB Name and a loading
behind the name. I can´t delete the DB with Enterprise manager, can´t open
the properties nothing.
I have tried in Sql Query analyzer to drop the database, but I´ve got an
error that the db can´t be deleted because an use for replication exist.
On the Sql Server where I have restored the DB is no replication configured
only on the sql server where the backup was made.
Any idea how to remove the DB?
(Sql Server 2000 sp3)
Thx
BjörnPerhaps the restore was done using NORECOVERY option? Try:
RESTORE DATABASE dbname WITH RECOVERY
That would make the database accessible. Then drop the database, possibly removing replication
config first if needed (Google for details...).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Björn" <prodevelop@.gmx.net> wrote in message news:O0SgxiqyGHA.3568@.TK2MSFTNGP03.phx.gbl...
> Hello
> I have a problem with a loading DB in Enterprise Manager.
> I had restored a DB from another Sql Server and something seems wrong. I´ve
> got no error message but I have a grey DB Icon with my DB Name and a loading
> behind the name. I can´t delete the DB with Enterprise manager, can´t open
> the properties nothing.
> I have tried in Sql Query analyzer to drop the database, but I´ve got an
> error that the db can´t be deleted because an use for replication exist.
> On the Sql Server where I have restored the DB is no replication configured
> only on the sql server where the backup was made.
> Any idea how to remove the DB?
> (Sql Server 2000 sp3)
> Thx
> Björn
>|||Hi,
Add on to Tibor; You could also try
RESTORE LOG dbname WITH RECOVERY
Thanks
Hari
SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ehrzeNsyGHA.4976@.TK2MSFTNGP04.phx.gbl...
> Perhaps the restore was done using NORECOVERY option? Try:
> RESTORE DATABASE dbname WITH RECOVERY
> That would make the database accessible. Then drop the database, possibly
> removing replication config first if needed (Google for details...).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Björn" <prodevelop@.gmx.net> wrote in message
> news:O0SgxiqyGHA.3568@.TK2MSFTNGP03.phx.gbl...
>> Hello
>> I have a problem with a loading DB in Enterprise Manager.
>> I had restored a DB from another Sql Server and something seems wrong.
>> I´ve
>> got no error message but I have a grey DB Icon with my DB Name and a
>> loading
>> behind the name. I can´t delete the DB with Enterprise manager, can´t
>> open
>> the properties nothing.
>> I have tried in Sql Query analyzer to drop the database, but I´ve got an
>> error that the db can´t be deleted because an use for replication exist.
>> On the Sql Server where I have restored the DB is no replication
>> configured
>> only on the sql server where the backup was made.
>> Any idea how to remove the DB?
>> (Sql Server 2000 sp3)
>> Thx
>> Björn
>>
>|||Hi
Thx for your answer
Now the DB is deleted:)
regards
Björn
"Hari Prasad" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:#tECW2wyGHA.3568@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Add on to Tibor; You could also try
> RESTORE LOG dbname WITH RECOVERY
> Thanks
> Hari
> SQL Server MVP
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:ehrzeNsyGHA.4976@.TK2MSFTNGP04.phx.gbl...
> > Perhaps the restore was done using NORECOVERY option? Try:
> >
> > RESTORE DATABASE dbname WITH RECOVERY
> >
> > That would make the database accessible. Then drop the database,
possibly
> > removing replication config first if needed (Google for details...).
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Björn" <prodevelop@.gmx.net> wrote in message
> > news:O0SgxiqyGHA.3568@.TK2MSFTNGP03.phx.gbl...
> >> Hello
> >>
> >> I have a problem with a loading DB in Enterprise Manager.
> >> I had restored a DB from another Sql Server and something seems wrong.
> >> I´ve
> >> got no error message but I have a grey DB Icon with my DB Name and a
> >> loading
> >> behind the name. I can´t delete the DB with Enterprise manager, can´t
> >> open
> >> the properties nothing.
> >> I have tried in Sql Query analyzer to drop the database, but I´ve got
an
> >> error that the db can´t be deleted because an use for replication
exist.
> >> On the Sql Server where I have restored the DB is no replication
> >> configured
> >> only on the sql server where the backup was made.
> >> Any idea how to remove the DB?
> >> (Sql Server 2000 sp3)
> >>
> >> Thx
> >>
> >> Björn
> >>
> >>
> >
>
I have a problem with a loading DB in Enterprise Manager.
I had restored a DB from another Sql Server and something seems wrong. I´ve
got no error message but I have a grey DB Icon with my DB Name and a loading
behind the name. I can´t delete the DB with Enterprise manager, can´t open
the properties nothing.
I have tried in Sql Query analyzer to drop the database, but I´ve got an
error that the db can´t be deleted because an use for replication exist.
On the Sql Server where I have restored the DB is no replication configured
only on the sql server where the backup was made.
Any idea how to remove the DB?
(Sql Server 2000 sp3)
Thx
BjörnPerhaps the restore was done using NORECOVERY option? Try:
RESTORE DATABASE dbname WITH RECOVERY
That would make the database accessible. Then drop the database, possibly removing replication
config first if needed (Google for details...).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Björn" <prodevelop@.gmx.net> wrote in message news:O0SgxiqyGHA.3568@.TK2MSFTNGP03.phx.gbl...
> Hello
> I have a problem with a loading DB in Enterprise Manager.
> I had restored a DB from another Sql Server and something seems wrong. I´ve
> got no error message but I have a grey DB Icon with my DB Name and a loading
> behind the name. I can´t delete the DB with Enterprise manager, can´t open
> the properties nothing.
> I have tried in Sql Query analyzer to drop the database, but I´ve got an
> error that the db can´t be deleted because an use for replication exist.
> On the Sql Server where I have restored the DB is no replication configured
> only on the sql server where the backup was made.
> Any idea how to remove the DB?
> (Sql Server 2000 sp3)
> Thx
> Björn
>|||Hi,
Add on to Tibor; You could also try
RESTORE LOG dbname WITH RECOVERY
Thanks
Hari
SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ehrzeNsyGHA.4976@.TK2MSFTNGP04.phx.gbl...
> Perhaps the restore was done using NORECOVERY option? Try:
> RESTORE DATABASE dbname WITH RECOVERY
> That would make the database accessible. Then drop the database, possibly
> removing replication config first if needed (Google for details...).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Björn" <prodevelop@.gmx.net> wrote in message
> news:O0SgxiqyGHA.3568@.TK2MSFTNGP03.phx.gbl...
>> Hello
>> I have a problem with a loading DB in Enterprise Manager.
>> I had restored a DB from another Sql Server and something seems wrong.
>> I´ve
>> got no error message but I have a grey DB Icon with my DB Name and a
>> loading
>> behind the name. I can´t delete the DB with Enterprise manager, can´t
>> open
>> the properties nothing.
>> I have tried in Sql Query analyzer to drop the database, but I´ve got an
>> error that the db can´t be deleted because an use for replication exist.
>> On the Sql Server where I have restored the DB is no replication
>> configured
>> only on the sql server where the backup was made.
>> Any idea how to remove the DB?
>> (Sql Server 2000 sp3)
>> Thx
>> Björn
>>
>|||Hi
Thx for your answer
Now the DB is deleted:)
regards
Björn
"Hari Prasad" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:#tECW2wyGHA.3568@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Add on to Tibor; You could also try
> RESTORE LOG dbname WITH RECOVERY
> Thanks
> Hari
> SQL Server MVP
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:ehrzeNsyGHA.4976@.TK2MSFTNGP04.phx.gbl...
> > Perhaps the restore was done using NORECOVERY option? Try:
> >
> > RESTORE DATABASE dbname WITH RECOVERY
> >
> > That would make the database accessible. Then drop the database,
possibly
> > removing replication config first if needed (Google for details...).
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Björn" <prodevelop@.gmx.net> wrote in message
> > news:O0SgxiqyGHA.3568@.TK2MSFTNGP03.phx.gbl...
> >> Hello
> >>
> >> I have a problem with a loading DB in Enterprise Manager.
> >> I had restored a DB from another Sql Server and something seems wrong.
> >> I´ve
> >> got no error message but I have a grey DB Icon with my DB Name and a
> >> loading
> >> behind the name. I can´t delete the DB with Enterprise manager, can´t
> >> open
> >> the properties nothing.
> >> I have tried in Sql Query analyzer to drop the database, but I´ve got
an
> >> error that the db can´t be deleted because an use for replication
exist.
> >> On the Sql Server where I have restored the DB is no replication
> >> configured
> >> only on the sql server where the backup was made.
> >> Any idea how to remove the DB?
> >> (Sql Server 2000 sp3)
> >>
> >> Thx
> >>
> >> Björn
> >>
> >>
> >
>
enterprise manager loading DB
Hello
I have a problem with a loading DB in Enterprise Manager.
I had restored a DB from another Sql Server and something seems wrong. Ive
got no error message but I have a grey DB Icon with my DB Name and a loading
behind the name. I cant delete the DB with Enterprise manager, cant open
the properties nothing.
I have tried in Sql Query analyzer to drop the database, but Ive got an
error that the db cant be deleted because an use for replication exist.
On the Sql Server where I have restored the DB is no replication configured
only on the sql server where the backup was made.
Any idea how to remove the DB?
(Sql Server 2000 sp3)
Thx
BjrnPerhaps the restore was done using NORECOVERY option? Try:
RESTORE DATABASE dbname WITH RECOVERY
That would make the database accessible. Then drop the database, possibly re
moving replication
config first if needed (Google for details...).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bjrn" <prodevelop@.gmx.net> wrote in message news:O0SgxiqyGHA.3568@.TK2MSFTNGP03.phx.gbl...[
vbcol=seagreen]
> Hello
> I have a problem with a loading DB in Enterprise Manager.
> I had restored a DB from another Sql Server and something seems wrong. Iv
e
> got no error message but I have a grey DB Icon with my DB Name and a loadi
ng
> behind the name. I cant delete the DB with Enterprise manager, cant open
> the properties nothing.
> I have tried in Sql Query analyzer to drop the database, but Ive got an
> error that the db cant be deleted because an use for replication exist.
> On the Sql Server where I have restored the DB is no replication configure
d
> only on the sql server where the backup was made.
> Any idea how to remove the DB?
> (Sql Server 2000 sp3)
> Thx
> Bjrn
>[/vbcol]|||Hi,
Add on to Tibor; You could also try
RESTORE LOG dbname WITH RECOVERY
Thanks
Hari
SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ehrzeNsyGHA.4976@.TK2MSFTNGP04.phx.gbl...
> Perhaps the restore was done using NORECOVERY option? Try:
> RESTORE DATABASE dbname WITH RECOVERY
> That would make the database accessible. Then drop the database, possibly
> removing replication config first if needed (Google for details...).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Bjrn" <prodevelop@.gmx.net> wrote in message
> news:O0SgxiqyGHA.3568@.TK2MSFTNGP03.phx.gbl...
>|||Hi
Thx for your answer
Now the DB is deleted
regards
Bjrn
"Hari Prasad" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:#tECW2wyGHA.3568@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Add on to Tibor; You could also try
> RESTORE LOG dbname WITH RECOVERY
> Thanks
> Hari
> SQL Server MVP
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:ehrzeNsyGHA.4976@.TK2MSFTNGP04.phx.gbl...
possibly[vbcol=seagreen]
an[vbcol=seagreen]
exist.[vbcol=seagreen]
>
I have a problem with a loading DB in Enterprise Manager.
I had restored a DB from another Sql Server and something seems wrong. Ive
got no error message but I have a grey DB Icon with my DB Name and a loading
behind the name. I cant delete the DB with Enterprise manager, cant open
the properties nothing.
I have tried in Sql Query analyzer to drop the database, but Ive got an
error that the db cant be deleted because an use for replication exist.
On the Sql Server where I have restored the DB is no replication configured
only on the sql server where the backup was made.
Any idea how to remove the DB?
(Sql Server 2000 sp3)
Thx
BjrnPerhaps the restore was done using NORECOVERY option? Try:
RESTORE DATABASE dbname WITH RECOVERY
That would make the database accessible. Then drop the database, possibly re
moving replication
config first if needed (Google for details...).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bjrn" <prodevelop@.gmx.net> wrote in message news:O0SgxiqyGHA.3568@.TK2MSFTNGP03.phx.gbl...[
vbcol=seagreen]
> Hello
> I have a problem with a loading DB in Enterprise Manager.
> I had restored a DB from another Sql Server and something seems wrong. Iv
e
> got no error message but I have a grey DB Icon with my DB Name and a loadi
ng
> behind the name. I cant delete the DB with Enterprise manager, cant open
> the properties nothing.
> I have tried in Sql Query analyzer to drop the database, but Ive got an
> error that the db cant be deleted because an use for replication exist.
> On the Sql Server where I have restored the DB is no replication configure
d
> only on the sql server where the backup was made.
> Any idea how to remove the DB?
> (Sql Server 2000 sp3)
> Thx
> Bjrn
>[/vbcol]|||Hi,
Add on to Tibor; You could also try
RESTORE LOG dbname WITH RECOVERY
Thanks
Hari
SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ehrzeNsyGHA.4976@.TK2MSFTNGP04.phx.gbl...
> Perhaps the restore was done using NORECOVERY option? Try:
> RESTORE DATABASE dbname WITH RECOVERY
> That would make the database accessible. Then drop the database, possibly
> removing replication config first if needed (Google for details...).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Bjrn" <prodevelop@.gmx.net> wrote in message
> news:O0SgxiqyGHA.3568@.TK2MSFTNGP03.phx.gbl...
>|||Hi
Thx for your answer
Now the DB is deleted
regards
Bjrn
"Hari Prasad" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:#tECW2wyGHA.3568@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Add on to Tibor; You could also try
> RESTORE LOG dbname WITH RECOVERY
> Thanks
> Hari
> SQL Server MVP
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:ehrzeNsyGHA.4976@.TK2MSFTNGP04.phx.gbl...
possibly[vbcol=seagreen]
an[vbcol=seagreen]
exist.[vbcol=seagreen]
>
Subscribe to:
Posts (Atom)