Forum Replies Created

Viewing 15 posts - 4,036 through 4,050 (of 9,253 total)

  • RE: DATABASE BACK UP PROBLEM

    Copy_only is detailed in books online.

    Yes provide the script to the developers

    backup database [yourdb] to disk = 'f:\somepath\yourdb.bak' WITH COPY_ONLY

    July 16, 2013 at 12:29 am

    #1632762

  • RE: Moving storage (SAN hp -> eva) with SQL Mirroring

    saqlainkhan (7/15/2013)

    We have a request come in to have the storage moved form HP--> EVA. The server that is part of this has SQL Mirroring on this.

    What will be...

    July 16, 2013 at 12:24 am

    #1632761

  • RE: DATABASE BACK UP PROBLEM

    Mr. Kapsicum (7/15/2013)

    some Developer takes a full backup of the database in an emergency or any situation,, then in that case,,, the Monday differential backup will be of the Latest...

    July 16, 2013 at 12:15 am

    #1632759

  • RE: SQL Disk Error

    adeel.imtiaz (7/15/2013)

    Please see that

    the shared storage can be seen on both machines when one fail.

    Let me explain to you.

    There are two nodes and 1 san.

    shared storage are configured on...

    July 16, 2013 at 12:10 am

    #1632758

  • RE: How to take backup of Single table and how to restore?

    Vlad-207446 (7/15/2013)

    if you are working with SQL2010

    Do you mean 2008 of 2012?

    July 15, 2013 at 10:02 am

    #1632549

  • RE: how to find log shipped databases in given server

    mac_live (7/15/2013)

    Hi all,

    I am really hard to finding how many databases are under logshipping in a given server. also that script need to get databases (means that script support any...

    July 15, 2013 at 8:59 am

    #1632515

  • RE: Database Mirroring Or Log shipping??

    $w@t (7/15/2013)

    thank you for reply...

    I am using sql server 2008 R2...

    Given this, what is your allowable latency for restoring the logs?

    July 15, 2013 at 8:21 am

    #1632487

  • RE: Raid 10

    msimone (7/15/2013)

    Hello.

    The average bytes/read is between 64k and 128k and the average bytes/write is between 32k and 64k.

    What is the best, Raid 10 2+2 with stripe size 128k and cluster...

    July 15, 2013 at 8:19 am

    #1632486

  • RE: How to take backup of Single table and how to restore?

    gaddamshiva (7/13/2013)

    Hi...

    How to take backup of Single table and how to restore? is there any query like database backup?

    shivakumar...

    if you want to just copy the data...

    July 15, 2013 at 8:16 am

    #1632482

  • RE: SQL Disk Error

    The cluster cannot see any shared disks

    have you presented the storage to all nodes that will participate in the failover cluster instance?

    have you added the new storage to the cluster...

    July 15, 2013 at 8:12 am

    #1632480

  • RE: In 2012, how to create a fully contained database?

    This link explains further

    July 11, 2013 at 8:12 am

    #1631595

  • RE: Piecemeal restore takes forever

    stakes (7/11/2013)

    The machine is in a seperate virtual testenvironment with old hardware and I don't have the space to restore the entire database. In another testenvironment, with better h/w, it...

    July 11, 2013 at 8:07 am

    #1631592

  • RE: install SQL cluster

    The guide uses Windows 2008 virtual machines running under VMWare Server 2.0 😉

    July 10, 2013 at 7:33 am

    #1631214

  • RE: Register SPN?

    ananda.murugesan (7/10/2013)

    yes, we are using windows 2008 operating system...

    SQL Service account running under windows local users.. But domain users are added into SQL logins for connection between database and application...so...

    July 10, 2013 at 7:31 am

    #1631210

  • RE: install SQL cluster

    See my 3 part guide at the following links

    Part1[/url]

    Part2[/u][/url]

    Part3[/url]

    July 10, 2013 at 3:45 am

    #1631134

Viewing 15 posts - 4,036 through 4,050 (of 9,253 total)