Showing posts with label log. Show all posts
Showing posts with label log. Show all posts

Sunday, March 25, 2012

Cannot drop database 'Tara' because it is being used for replicati

One of our critical databases that is part of a log shipping-like set up is
corrupt. This happened while doing a full DEb restore. DB was showing status
'Loading/Suspect' for about 5 hours. However, restore job has failed, and
nothing is attempting to restore it. I am unable to get get any information
of the DB via Query Analyzer or Enterprise Manager.
I need to drop this DB and recreate it, but I am unable to do any
drop/delete operation on this DB as well.
About an hour ago, I stoped the SQL Server, and deleted the .mdf and .ldf
files from the physical location. When I start the SQL Server back up, the DB
is still visible, and I am not able to do anything with it.
When I try to drop the database I get following error.
"Cannot drop database 'Tara' because it is being used for replication." We
don't have any replicaiton set up going on at all.
IF I do sp_helpDB it gives me following message
No permission to access database 'Tara'. I am logged on as sa.
Anyone knows what is going on hear?
Thank you
BlueFish
use master
go
exec sp_removedbreplication 'Tara'
go
drop database 'Tara'
Geoff N. Hiten
Microsoft SQL Server MVP
"bluefish" <bluefish@.discussions.microsoft.com> wrote in message
news:CB38AC55-B701-4CA0-88A1-3A2706D8933B@.microsoft.com...
> One of our critical databases that is part of a log shipping-like set up
> is
> corrupt. This happened while doing a full DEb restore. DB was showing
> status
> 'Loading/Suspect' for about 5 hours. However, restore job has failed,
> and
> nothing is attempting to restore it. I am unable to get get any
> information
> of the DB via Query Analyzer or Enterprise Manager.
> I need to drop this DB and recreate it, but I am unable to do any
> drop/delete operation on this DB as well.
> About an hour ago, I stoped the SQL Server, and deleted the .mdf and .ldf
> files from the physical location. When I start the SQL Server back up, the
> DB
> is still visible, and I am not able to do anything with it.
> When I try to drop the database I get following error.
> "Cannot drop database 'Tara' because it is being used for replication." We
> don't have any replicaiton set up going on at all.
>
> IF I do sp_helpDB it gives me following message
> No permission to access database 'Tara'. I am logged on as sa.
>
> Anyone knows what is going on hear?
> Thank you
> BlueFish
>
>
sql

Thursday, March 22, 2012

cannot delete user & shrink log file

Hello... I'm facing two problems:
1. When I try to delete a user from a specific database,
it reports that that user cannot be dropped as it owns
objects. The db_owner is 'sa' not this user.
2. When I try to shrink the size of my log file, it
reports, "Cannot shrink log file 2 (cms1_log) because all
logical log files are in use."
Please help. Thanks.1. My guess is that the user own some objects. If you are used to
Enterprise Manager then expand each objects list and see if the user own
anything like "tables", "views", "store procedure", "user defined functions"
...
2. What is your recovery model? Right click server in EM, then click
properties, then options
"Rob" <rhchin@.hotmail.com> wrote in message
news:5d8901c35784$5b35fbf0$a001280a@.phx.gbl...
> Hello... I'm facing two problems:
> 1. When I try to delete a user from a specific database,
> it reports that that user cannot be dropped as it owns
> objects. The db_owner is 'sa' not this user.
> 2. When I try to shrink the size of my log file, it
> reports, "Cannot shrink log file 2 (cms1_log) because all
> logical log files are in use."
> Please help. Thanks.|||Rob,
#1..It could also be that that the user owns other objects like table,
stored procedures etc.Using the below query, you can find out the objects:
SELECT [name]
FROM sysobjects
WHERE uid=USER_ID('<user_name>')
Once there, try to change the ownership to another user, using
sp_changeobjectowner.
#2.Refer
INF: How to Shrink the SQL Server 7.0 Transaction Log
http://support.microsoft.com/support/kb/Articles/q256/6/50.asp
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/support/kb/Articles/q272/3/18.asp
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Rob" <rhchin@.hotmail.com> wrote in message
news:5d8901c35784$5b35fbf0$a001280a@.phx.gbl...
> Hello... I'm facing two problems:
> 1. When I try to delete a user from a specific database,
> it reports that that user cannot be dropped as it owns
> objects. The db_owner is 'sa' not this user.
> 2. When I try to shrink the size of my log file, it
> reports, "Cannot shrink log file 2 (cms1_log) because all
> logical log files are in use."
> Please help. Thanks.|||Thanks for your response...
>Once there, try to change the ownership to another user,
using
>sp_changeobjectowner.
I can see many objects owned by the user I wish to drop.
However, when I try to use the sp_changeobjectowner sproc,
it tells me that the object does not exist or is not a
valid object for this operation.
Thanks again.

Tuesday, March 20, 2012

Cannot Crete server object

I'm using a client software to connect to a server. Everytime I try to log in
to that software an error: " ERROR 70: Cannot Create Servre Object". I
currently use a Microsoft Advanced server with the clients having a WIndows
XP OS.
What do I need to do?
Contact your Software Vendor. It is not a SQL Server error, but an error
that is only understood by the vendor.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"thescene" <thescene@.discussions.microsoft.com> wrote in message
news:8C17E98A-A16F-4EEF-AE8F-D32F851B63F7@.microsoft.com...
> I'm using a client software to connect to a server. Everytime I try to log
> in
> to that software an error: " ERROR 70: Cannot Create Servre Object". I
> currently use a Microsoft Advanced server with the clients having a
> WIndows
> XP OS.
> What do I need to do?
|||I just changed my switch, is that a possible reason why it's not working
anymore?
Joseph
"Mike Epprecht (SQL MVP)" wrote:

> Contact your Software Vendor. It is not a SQL Server error, but an error
> that is only understood by the vendor.
> Regards
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "thescene" <thescene@.discussions.microsoft.com> wrote in message
> news:8C17E98A-A16F-4EEF-AE8F-D32F851B63F7@.microsoft.com...
>
>
sql

Thursday, March 8, 2012

Cannot create a connection to data source

When I log onto my test report services 2005 I can run this report fine after deploying it using IE on the reportserver. However when I go back to my own PC, I get this error when trying to access the report from my PC browser:

  • An error has occurred during report processing.
  • Cannot create a connection to data source 'MBNATEST'.
  • For more information about this error navigate to the report server on the local server machine, or enable remote errorsnevermind, figured it out myself:

    In Report Manager

    1) Click on Properties
    2) Click on Data Sources
    3) Make your Data Source Shared

  • Wednesday, March 7, 2012

    cannot copy files

    I copied a database using backup and restore from Sql server 2000 to Sql server 2005. I noticed the data(mdf) and log(ldf) files did not copy. when I try to do a copy and past it gives me an error: cannot copy lof: it is being used by another person or program. Close all programs and try again. Does this mean I have to stop both servers to copy between them? Please help.just to clarify, did you successfully restore the db on 2005? if so, then I assure you the mdf and ldf are there. maybe they are not where you think they should be however.

    to find out where they are, do this:

    use MyDatabase
    exec sp_helpfile

    Cannot connect with ODBC using TCP/IP?

    Win 2003 Small business server with IIS being used as a web server.
    Our client app can log in and run queries, but our web app when trying to log in gets the message,
    'SQL server does not exsist or access denied'
    The system DSN's are both sql drivers and the configuration is name pipes. Our recomended specs use TCP/IP, but when I try to change it, it craps out on me. He's opened up his firewall completely to this new box and his old box, a Win2k machine can connect using TCP/IP. This machine is in a work group.
    Any suggestions on what it might be? :confused:instead of dsn, try dsn-less:
    http://www.connectionstrings.com/

    Friday, February 10, 2012

    Cannot Connect to Analysis Server-not a member of OLAP Admin

    I have set up the the Analysis Service to log on as DOMAIN\administrator.
    I have added DOMAIN\administrator as a member of OLAP Adminitration
    I initially logged in as DOMAIN\administrator.
    Upon trying to connect in Analysis Server, I get the error messge Cannot
    connect to SERVER registry or you are not a member of the OLAP
    AdministratorGroup
    What gives? How do I resolve this?
    Are you running the latest service pack for Analysis Services?
    Kevin E.
    "Diane" <Diane@.discussions.microsoft.com> wrote in message
    news:B2888652-78F9-4F32-88B2-F21C03A48A65@.microsoft.com...
    >I have set up the the Analysis Service to log on as DOMAIN\administrator.
    > I have added DOMAIN\administrator as a member of OLAP Adminitration
    > I initially logged in as DOMAIN\administrator.
    > Upon trying to connect in Analysis Server, I get the error messge Cannot
    > connect to SERVER registry or you are not a member of the OLAP
    > AdministratorGroup
    > What gives? How do I resolve this?
    |||Yes, I am.
    "Diane" wrote:

    > I have set up the the Analysis Service to log on as DOMAIN\administrator.
    > I have added DOMAIN\administrator as a member of OLAP Adminitration
    > I initially logged in as DOMAIN\administrator.
    > Upon trying to connect in Analysis Server, I get the error messge Cannot
    > connect to SERVER registry or you are not a member of the OLAP
    > AdministratorGroup
    > What gives? How do I resolve this?
    |||We had the same problem on some of our installations. Seems like after we
    rebooted and then tried to connect it worked fine. Might of had something to
    do with MSSQLServerOLAPService not being started until after reboot. Just a
    thought.
    Kevin
    "Diane" <Diane@.discussions.microsoft.com> wrote in message
    news:904C6394-D5AE-4BC4-8A45-39B58AA742BD@.microsoft.com...[vbcol=seagreen]
    > Yes, I am.
    > "Diane" wrote: