Forum Replies Created

Viewing 15 posts - 121 through 135 (of 170 total)

  • RE: Need to add a user to a read only database

    sturner (3/22/2012)

    Benki Chendu (3/22/2012)

    ohh..I am in trouble now..

    I don't know from where the customer got the database backup from..

    Here is what I did...

    Restored the database with recovery..

    Added that windows user...

    March 22, 2012 at 9:30 am

    #1462819

  • RE: Need to add a user to a read only database

    ohh..I am in trouble now..

    I don't know from where the customer got the database backup from..

    Here is what I did...

    Restored the database with recovery..

    Added that windows user to the database...

    March 22, 2012 at 9:20 am

    #1462809

  • RE: Need to add a user to a read only database

    GilaMonster (3/22/2012)

    If it's a log shipping secondary, add the user to the primary DB and make sure that the SIDs of the logins are the same on both servers.

    Its not...

    March 22, 2012 at 9:03 am

    #1462790

  • RE: Need to add a user to a read only database

    Lynn Pettis (3/22/2012)

    Benki Chendu (3/22/2012)

    The DB is in Standby too..Does it still work the way you advised..

    No. Looks like the database may be the target of log shipping or...

    March 22, 2012 at 9:03 am

    #1462787

  • RE: Need to add a user to a read only database

    I have another relevant doubt..

    There is a windows user named X which is there on my production server and it has DBO rights on my production database..

    Now, I want to...

    March 22, 2012 at 9:02 am

    #1462785

  • RE: Need to add a user to a read only database

    The DB is in Standby too..Does it still work the way you advised..

    March 22, 2012 at 8:56 am

    #1462780

  • RE: backup/copy standby/read-only database

    But I am trying to restore the database on an entirely different server?

    March 21, 2012 at 4:14 am

    #1462072

  • RE: backup/copy standby/read-only database

    I got a different backup file and when I try to restore it, I am getting the following error:

    'E:\MSSQL\Transaction.bak' is claimed by 'contract'(3) and 'contracts'(1). The WITH MOVE clause can...

    March 21, 2012 at 4:09 am

    #1462070

  • RE: backup/copy standby/read-only database

    I don't think this is in log shipping...

    I checked the DB properties and didn't find it to be in log shipping..

    March 20, 2012 at 8:39 am

    #1461664

  • RE: Log record ID corruption

    rfr.ferrari (3/7/2012)

    are they running administrative commands on server? (for example: DBCC) or the access only by website without admin commands?

    They access only by website without admin commands as per my...

    March 7, 2012 at 4:47 am

    #1455884

  • RE: Log record ID corruption

    rfr.ferrari (3/7/2012)

    Benki Chendu (3/7/2012)

    ...... state_desc is showing as online only..

    is database working fine?

    did you lost any data???

    It seems to be working fine now.

    But, we had a P1 incident over the...

    March 7, 2012 at 4:26 am

    #1455872

  • RE: Log record ID corruption

    GilaMonster (3/7/2012)

    Query sys.databases, not the old sysdatabases view. I can't recall offhand if it's state_desc or status_desc, query it and see, post the value.

    The old sysdatabases view is for backward...

    March 7, 2012 at 4:00 am

    #1455857

  • RE: Log record ID corruption

    rfr.ferrari (3/7/2012)

    execute the follow t-sql:

    select name, state_desc from sys.databases

    where name = 'maximum'

    Error message:

    Msg 207, Level 16, State 1, Line 1

    Invalid column name 'status_desc'.

    March 7, 2012 at 3:28 am

    #1455840

  • RE: Log record ID corruption

    GilaMonster (3/6/2012)

    Status_desc

    I see only the status and status2 columns and following are the values:

    Status - 16

    Status2 - 1090519040

    March 7, 2012 at 2:59 am

    #1455825

  • RE: Log record ID corruption

    GilaMonster (3/6/2012)

    What state is the database in at the moment? (state_desc in sys.databases)

    I am afraid, I don't find the state_desc column in sys.databases..

    March 6, 2012 at 9:37 am

    #1455436

Viewing 15 posts - 121 through 135 (of 170 total)