Forum Replies Created

Viewing 15 posts - 151 through 165 (of 243 total)

  • RE: Installing Service pack

    ananthbhaskar (3/17/2010)

    Applying Hotfix on test and DEV enviorment is always the best practice, but while applying patches plz keep in mind to stop sql services , bcoz it mostly aviods...

    March 18, 2010 at 8:13 am

    #1135985

  • RE: ISOLATION IN DEADLOCK

    Saravanan T (1/27/2010)

    How to check it???? Can elaborate on it????

    Are you using the ramco erp product ?

    January 27, 2010 at 2:38 am

    #1109174

  • RE: SQL Log

    CirquedeSQLeil (1/23/2010)

    It looks like you might have a corrupted registry string.

    Check the following:

    http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/72afb885-c158-4508-bfd2-61f3a877a940

    i coud not resovle this issue by using the link which you have mentioned above. can you tell...

    January 27, 2010 at 12:28 am

    #1109136

  • RE: ISOLATION IN DEADLOCK

    Saravanan T (1/26/2010)

    Hi,

    Isolation level of my database is "Read Committed Snapshot". A deadlock as occurred , but it is showing the isolation level as "Serializable"....

    January 27, 2010 at 12:22 am

    #1109134

  • RE: SQL Configuration Manager Problem

    Perry Whittle (1/25/2010)

    are you copying and pasting the text from this site to the command prompt?

    if not, can you post the exact command you are using?

    i have tried the same...

    January 26, 2010 at 7:00 am

    #1108638

  • RE: SQL Configuration Manager Problem

    Mani Singh (7/13/2008)

    Try this solution:Goto Start-RUN-CMD (command Prompt)

    then run this command. whatever the path of your SQL Binaries....

    C:\Program Files\Microsoft SQL Server\90\Shared>mofcomp "C:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof"

    hi.. i am also having the...

    January 25, 2010 at 10:04 am

    #1108248

  • RE: Updates System Catalogs

    Lynn Pettis (1/19/2010)

    Ramji29 (1/19/2010)

    try this.

    USE master

    EXEC sp_configure 'show advanced option', '1'

    go

    RECONFIGURE WITH OVERRIDE

    go

    EXEC sp_configure 'allow updates', '1'

    go

    RECONFIGURE WITH OVERRIDE

    go

    --Now update the table u wanna update

    begin tran

    update master.sys.sysdatabases set status =...

    January 21, 2010 at 7:18 am

    #1106683

  • RE: Log Shipping

    george sibbald (1/10/2010)

    disable all logshipping jobs

    on primary move log backups out of logshipping directory to another directory

    on secondary delete log backups from log shipping directory

    on primary take full backup (ensure...

    January 11, 2010 at 8:56 am

    #1101862

  • RE: Auto Start

    Are you getting error messages while starting the sql server services manually ?

    January 10, 2010 at 10:34 am

    #1101524

  • RE: Log Shipping

    george sibbald (1/10/2010)

    you will have to try and find those missing log backups and manually copy them over and restore them. If you cannot find them or someone has truncated...

    January 10, 2010 at 10:20 am

    #1101522

  • RE: Master Database

    Thanks for your reply....

    January 7, 2010 at 10:15 am

    #1100344

  • RE: Recover Data File - MDF

    Jack Corbett (1/4/2010)

    Sorry to say that you are basically screwed since you have no backups. Your only option is to run DBCC CHECKDB or CHECKTABLE with one of the...

    January 4, 2010 at 8:45 am

    #1098472

  • RE: Recover Data File - MDF

    tosscrosby-60625 (1/4/2010)

    Restore from a vaild backup, provided you have one?

    No .... i do not have back up of the database.

    January 4, 2010 at 8:05 am

    #1098438

  • RE: Corrupt SQL MDF

    Grant Fritchey (12/30/2009)

    Shut down the server, muck with the file using an editor as Steve said, restart the server. Tada. Totally hosed database.

    thanks .. data base file has corrupted successfully...

    December 31, 2009 at 8:46 am

    #1097889

  • RE: Corrupt SQL MDF

    Steve Jones - Editor (12/30/2009)

    Do you mean make a corrupt mdf on purpose?

    Use a hex editor to scribble on some random part of the file.

    Yes.. ok will try and update...

    December 30, 2009 at 10:30 am

    #1097560

Viewing 15 posts - 151 through 165 (of 243 total)