Error 927

I recently restored a database from tape.
However when I go into SQL Enterprise Manager, I see the
recently restored database showing "loading".
I assumed that this was a good indication however it has
been loading now for the last 12 hours. The database is
about 17 gig.
Is this normal or is it safe to assume that is locked up.
What am I missing here.
Thank a million!
JamesIf you run sp_who2 do you see any RESTORE spids ? If not it may well be that
you just need to run RESTORE DATABASE dbname WITH RECOVERY to recover and
access the database.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
<James@.discussions.microsoft.com> wrote in message
news:045601c3cfb6$8a186d40$a001280a@.phx.gbl...
> I recently restored a database from tape.
> However when I go into SQL Enterprise Manager, I see the
> recently restored database showing "loading".
> I assumed that this was a good indication however it has
> been loading now for the last 12 hours. The database is
> about 17 gig.
> Is this normal or is it safe to assume that is locked up.
> What am I missing here.
> Thank a million!
> James
>|||Hi James,
How did you restore the database? Are you using any third party tool?
Certain third party tool such as Arcserv may have option for you to
"recover" the database after the restore. If not, it will stay in
loading status until you recover the database manually
To recover the database manually, you can just run the following
statement
restore database <dbname> with recovery
Yih-Yoon Lee
<James@.discussions.microsoft.com> wrote in message news:<045601c3cfb6$8a186d40$a001280a@.phx.gbl>...
> I recently restored a database from tape.
> However when I go into SQL Enterprise Manager, I see the
> recently restored database showing "loading".
> I assumed that this was a good indication however it has
> been loading now for the last 12 hours. The database is
> about 17 gig.
> Is this normal or is it safe to assume that is locked up.
> What am I missing here.
> Thank a million!
> James

Error 927

I recently restored a database from tape.
However when I go into SQL Enterprise Manager, I see the
recently restored database showing "loading".
I assumed that this was a good indication however it has
been loading now for the last 12 hours. The database is
about 17 gig.
Is this normal or is it safe to assume that is locked up.
What am I missing here.
Thank a million!
JamesThat is really hard to tell. 12 hours sounds a bit excessive. What version
of SQL? I've restored 1-2 GB databases with SQL 7/2000 in 30 mins.
My one thought is that there may be a very long running transaction that has
to be rolled back. Do you have another backup to try restoring from? You
could always create a separate database on the same server, and force a
restore on that one.
Also, does sp_who reveal any blocks or ROLLBACK transactions? Where is
error 927 show up? When you restored, on the Advanced tab, it did say Leave
database operational, and not one of the other options where you could
restore additional backups, right?
I assume this KB article is not applicable as it is for the msdb database,
but I'll put in just in case
http://support.microsoft.com/defaul...kb;en-us;319701 (Error 927
restoring the msdb database).
Good luck.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
<James@.discussions.microsoft.com> wrote in message
news:045b01c3cfb6$9d4f18f0$a001280a@.phx.gbl...

quote:

---

> I recently restored a database from tape.
> However when I go into SQL Enterprise Manager, I see the
> recently restored database showing "loading".
> I assumed that this was a good indication however it has
> been loading now for the last 12 hours. The database is
> about 17 gig.
> Is this normal or is it safe to assume that is locked up.
> What am I missing here.
> Thank a million!
> James
>

---

sql

Error 5063: database .. is in warm standby. A warm-standby is read only.

A freshly restored DB is readonly(I choose "readonly" ,when restore it).
The restore was successful ,but when try to change it to readwrite .
Error 5063 poped up.
I found on information in support KB ,please help..
Thanks!!.
You could try this:
USE MASTER
GO
RESTORE DATABASE <database name> WITH RECOVERY
GO
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Straight" <someone@.> wrote in message
news:ug4xtUMLEHA.2736@.TK2MSFTNGP11.phx.gbl...
>A freshly restored DB is readonly(I choose "readonly" ,when restore it).
> The restore was successful ,but when try to change it to readwrite .
> Error 5063 poped up.
> I found on information in support KB ,please help..
> Thanks!!.
>

Error 5063: database .. is in warm standby. A warm-standby is read only.

A freshly restored DB is readonly(I choose "readonly" ,when restore it).
The restore was successful ,but when try to change it to readwrite .
Error 5063 poped up.
I found on information in support KB ,please help..
Thanks!!.You could try this:
USE MASTER
GO
RESTORE DATABASE <database name> WITH RECOVERY
GO
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Straight" <someone@.> wrote in message
news:ug4xtUMLEHA.2736@.TK2MSFTNGP11.phx.gbl...
>A freshly restored DB is readonly(I choose "readonly" ,when restore it).
> The restore was successful ,but when try to change it to readwrite .
> Error 5063 poped up.
> I found on information in support KB ,please help..
> Thanks!!.
>

Error 5063: database .. is in warm standby. A warm-standby is read only.

A freshly restored DB is readonly(I choose "readonly" ,when restore it).
The restore was successful ,but when try to change it to readwrite .
Error 5063 poped up.
I found on information in support KB ,please help..
Thanks!!.You could try this:
USE MASTER
GO
RESTORE DATABASE <database name> WITH RECOVERY
GO
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Straight" <someone@.> wrote in message
news:ug4xtUMLEHA.2736@.TK2MSFTNGP11.phx.gbl...
>A freshly restored DB is readonly(I choose "readonly" ,when restore it).
> The restore was successful ,but when try to change it to readwrite .
> Error 5063 poped up.
> I found on information in support KB ,please help..
> Thanks!!.
>

Error 50007: xp_execresultset: unable to get a bound connection back to server

Hi,
I have just resinstalled my server and restored the backup of my database. I am now trying to re-setup replication and I get the above error. The server configuiration:
Win2k3
SQL Server 2000 SP4
Replication: Distributor & Publisher (intended Push Publisher)
Snapshot
Subscriber: Remote server
I have looked around the web for similar problems and resolutions but mine still does not want to work. I have completely removed the replication as per the information on this article: http://support.microsoft.com/kb/324401 but still cannot get it working.
I did not backup the distribution db, master or msdb - only the main database I want to replicate.
Any advice?
Thanx
Dave
From http://www.developmentnow.com/g/114_0_0_0_0_0/sql-server-replication.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com
You get this error when you have not set up your administrative link
password correctly. Either uncheck this option or ensure that when you
configure your publisher you enter the correct one.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dave" <nospam@.developmentnow.com> wrote in message
news:2ae92f81-6f29-41d1-ba10-e7841b355fbb@.developmentnow.com...
> Hi,
> I have just resinstalled my server and restored the backup of my database.
> I am now trying to re-setup replication and I get the above error. The
> server configuiration:
> Win2k3
> SQL Server 2000 SP4
> Replication: Distributor & Publisher (intended Push Publisher)
> Snapshot
> Subscriber: Remote server
> I have looked around the web for similar problems and resolutions but mine
> still does not want to work. I have completely removed the replication as
> per the information on this article:
> http://support.microsoft.com/kb/324401 but still cannot get it working.
> I did not backup the distribution db, master or msdb - only the main
> database I want to replicate.
> Any advice?
> Thanx
> Dave
> From
> http://www.developmentnow.com/g/114_0_0_0_0_0/sql-server-replication.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
|||Hi,
Thanx for the information. I have managed to get it to work again by creating a new username and password for the distribution agents to use. Initially it was set to impersonate the service account (which is a domain account that the SQL Services use). I would have thought that this would be sufficient. I even gave this account sysadmin privledges.
Also, when I first setup the replication it worked without having to change any usernames and/or passwords. Was the problem because I recovered from a backup?
Thanx
Dave
From http://www.developmentnow.com/g/114_2007_7_0_0_995269/Error-50007-xp-execresultset-unable-to-get-a-bound-connection-back-to-server.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com
|||Its hard to say what caused the problem, but I am glad you have solved it.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dave" <nospam@.developmentnow.com> wrote in message
news:2258406d-86c6-4c5e-87e2-1283b7f9b4e6@.developmentnow.com...
> Hi,
> Thanx for the information. I have managed to get it to work again by
> creating a new username and password for the distribution agents to use.
> Initially it was set to impersonate the service account (which is a domain
> account that the SQL Services use). I would have thought that this would
> be sufficient. I even gave this account sysadmin privledges.
> Also, when I first setup the replication it worked without having to
> change any usernames and/or passwords. Was the problem because I recovered
> from a backup?
> Thanx
> Dave
> From
> http://www.developmentnow.com/g/114_2007_7_0_0_995269/Error-50007-xp-execresultset-unable-to-get-a-bound-connection-back-to-server.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com

Error 21002 [SQL-DMO] User 'already' exists

I have restored a database. Now I am trying to reset permissions on some accounts and this is the error I get. Even when I delete and re-establish acct, I get same thing. Can anyone help
ThanksSeems you want to read about sp_change_users_logins in Books Online. For a GUI on top of the
command, see:
http://www.dbmaint.com/SyncSqlLogins.asp
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"mmitchmcp" <mmitchmcp@.netscape.net> wrote in message
news:1E90A19D-BBB7-4B4A-A7FB-BCFE344A323D@.microsoft.com...
> I have restored a database. Now I am trying to reset permissions on some accounts and this is the
error I get. Even when I delete and re-establish acct, I get same thing. Can anyone help?
> Thanks|||I tried this application and it works great! Thank you

Error 21002 [SQL-DMO) User 'account' already exists

I restored a database and tried setting permissions on my accounts and recieved the following error:
Error 21002 [SQL-DMO] User acct already exists.
Whats this?
Can anyone help?
Thanks
MMSeems you want to read about sp_change_users_logins in Books Online. For a GUI on top of the
command, see:
http://www.dbmaint.com/SyncSqlLogins.asp
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"MM" <anonymous@.discussions.microsoft.com> wrote in message
news:832FD572-1F3A-4A2D-B027-A7B04BFE19EB@.microsoft.com...
> I restored a database and tried setting permissions on my accounts and recieved the following
error:
> Error 21002 [SQL-DMO] User acct already exists.
> Whats this?
> Can anyone help?
> Thanks
> MM|||Your sids do not match more than likely. When you create a
login(sysxlogins) a sid is made and when you add that login to a database as
a user the sid is copied(sysusers). The sid is unique and different on each
server, even for the same login name. You will not see the users in the
GUI(remember GUI is evil and dumb), however if you query the sysusers of
that database you will see those names. Drop all users using T-SQL and add
them back. Good luck.
"MM" <anonymous@.discussions.microsoft.com> wrote in message
news:832FD572-1F3A-4A2D-B027-A7B04BFE19EB@.microsoft.com...
> I restored a database and tried setting permissions on my accounts and
recieved the following error:
> Error 21002 [SQL-DMO] User acct already exists.
> Whats this?
> Can anyone help?
> Thanks
> MM|||"Kevin Brooks" <jeepnreb@.yahoo.com> wrote in message
news:eNzqsFMxDHA.2328@.TK2MSFTNGP10.phx.gbl...
> Your sids do not match more than likely. When you create a
> login(sysxlogins) a sid is made and when you add that login to a database
as
> a user the sid is copied(sysusers). The sid is unique and different on
each
> server, even for the same login name. You will not see the users in the
> GUI(remember GUI is evil and dumb), however if you query the sysusers of
> that database you will see those names. Drop all users using T-SQL and
add
> them back. Good luck.
> "MM" <anonymous@.discussions.microsoft.com> wrote in message
> news:832FD572-1F3A-4A2D-B027-A7B04BFE19EB@.microsoft.com...
> > I restored a database and tried setting permissions on my accounts and
> recieved the following error:
> >
> > Error 21002 [SQL-DMO] User acct already exists.
> >
> > Whats this?
> >
> > Can anyone help?
> >
> > Thanks
> >
> > MM
>

Error 21002 : User already exists

Running SQL Server 2000 Enterprise SP3a ( Windows Server 2003 )
I restored several databases from one instance ( on another box ) to another
. Now I am trying to add the users
to the second box ( to duplicate those on the first ) where I restored the d
ata and I am getting this error when
trying to add the database permissions for the user.
I tried working with sp_change_users, but the report shows nothing ( no rows
returned ) .
I tried deleting user using sp_droplogin, it dropped the user, but same thin
g happened again
once I readded him. I also tried the sp_change_users_login ( autofix) to no
avail ( nothing happened )
Any help would be appreciated.
ThanksRun select * from sysusers in the database that you are trying to add the
user. If the user does exist then run the sp_granddbaccess procedure to
grant access to the user. You may then need to run sp_change_users_login
again after verifying that the login exists for this user.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||That response should hav been sp_grantdbaccess.
Rand
This posting is provided "as is" with no warranties and confers no rights.