Forum Replies Created

Viewing 15 posts - 10,741 through 10,755 (of 49,552 total)

  • RE: Regarding backups and recovery model

    ALTER DATABASE <database name> SET RECOVERY FULL

    Please first read the two article I referenced above.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 4, 2013 at 6:18 am

    #1670685

  • RE: Replication Subscriber & Recovery Model

    Recovery model has no effect whatsoever on replication, that goes for publisher and subscriber alike.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 4, 2013 at 5:50 am

    #1670670

  • RE: Who is in the DBO group for all dbs.

    sys.sysmembers (Transact-SQL)

    This SQL Server 2000 system table is included as a view for backward compatibility. This feature will be removed in a future version of Microsoft SQL Server. Avoid...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 4, 2013 at 3:04 am

    #1670640

  • RE: Regarding backups and recovery model

    Have a read through these:

    http://www.sqlservercentral.com/articles/Administration/75461/

    http://www.sqlservercentral.com/articles/Administration/64582/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 4, 2013 at 2:58 am

    #1670638

  • RE: Regarding backups and recovery model

    Please don't cross post. It just wastes people's time and fragments replies

    No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1519531-391-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 4, 2013 at 2:57 am

    #1670637

  • RE: Procedure with default parameters

    Luis Cazares (12/3/2013)

    The second option is to default the values to NULL and assign values dinamically.

    CREATE PROCEDURE MyProcedure(

    @Param1 int = NULL,

    ...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 4, 2013 at 2:09 am

    #1670629

  • RE: adding a filed in table is impossible!!

    I don't know if it's due to permission because you still haven't posted the error. If there's an error, it would have been displayed in a dialog.

    Have you tried using...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 4, 2013 at 1:29 am

    #1670622

  • RE: adding a filed in table is impossible!!

    'Save as text file' is not an error. It's very hard to help you without knowing exactly what you're doing and having a description of the error you're getting.

    Are you...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 4, 2013 at 1:04 am

    #1670616

  • RE: Database Mirroring

    PRR.DB (12/3/2013)

    We are not taking log backups but we are taking week full backup.

    There's your problem. If a database is in full recovery, and for mirroring it has to...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 3, 2013 at 11:58 pm

    #1670606

  • RE: Database Mirroring

    Do you have regular log backups running? If not, that's why the log is so large.

    Please read through these:

    http://www.sqlservercentral.com/articles/Administration/64582/

    http://www.sqlservercentral.com/articles/Transaction+Logs/72488/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 3, 2013 at 11:49 pm

    #1670603

  • RE: Not able to execute as owner for attached databases

    The problem occurs when the owner of the database does not map to a login on that instance. The solution is, as per those google results, change the owner to...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 3, 2013 at 11:41 pm

    #1670600

  • RE: Finding the RAID level

    If the RAID was set up within Windows (software RAID), you can see it from disk management. If it was set up elsewhere, then you have to go and look...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 3, 2013 at 11:38 pm

    #1670597

  • RE: adding a filed in table is impossible!!

    What exactly are you trying to do, what is the exact error you're getting?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 3, 2013 at 11:37 pm

    #1670595

  • RE: Regarding tempdb usage

    nagasai88 (12/3/2013)

    but Sr. SQL developer in our company said that he had seen this kind of implemenation in his previous company so now he want's to implement same for CRM...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 3, 2013 at 10:08 pm

    #1670584

  • RE: Regarding tempdb usage

    nagasai88 (12/3/2013)

    So my question is there anyway I can setup like F drive user databases use F drive temdb file and G drive databases use G drive tempdb files.

    No.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 3, 2013 at 2:44 pm

    #1670549

Viewing 15 posts - 10,741 through 10,755 (of 49,552 total)