Forum Replies Created

Viewing 15 posts - 4,486 through 4,500 (of 9,253 total)

  • RE: Not able to connect db user in standby database

    ananda.murugesan (12/6/2012)

    I have doubt..

    I think if this didn't work as designed Microsoft would have known about it by now 😉

    ananda.murugesan (12/6/2012)

    Log shipping process have been configured on the primary database...

    December 6, 2012 at 5:08 am

    #1566103

  • RE: Download SQL Server 2012 64 bit Evaluation

    if you read the download instructions you are instructed to either

    • download full DVD ISO image and burn to disk

    • download the Lang.BOX Core.BOX and Install.EXE to a folder and extract the...

    December 6, 2012 at 3:02 am

    #1566060

  • RE: Not able to connect db user in standby database

    ananda.murugesan (12/6/2012)

    Thanks for reply..

    I try to created new user & login on the secondary server instance, but still facing same issues...not able to create new user on the standby read-only...

    December 6, 2012 at 2:56 am

    #1566058

  • RE: Log Shipping failing when the primary DB is taken offline

    Ravi-156610 (12/6/2012)

    We have Log Shipping setup on SQL 2008 instances and everything was running fine until the primary database was accidentally taken offline. We bought the DB online but noticed...

    December 6, 2012 at 2:53 am

    #1566057

  • RE: Mount Point quick question

    Mount points are a standard feature of the NTFS file system and have been for some time. Mounted volumes are very common on Unix systems too.

    December 5, 2012 at 11:48 pm

    #1566017

  • RE: Setting up log shipping for multiple databases

    jmaikido (12/5/2012)

    Hi Stephen,

    I have the exact same requirement whereby I have been given the task to LS multiple databases. approx. 25 @ this stage. (SQL2008R2) As I'm not one for...

    December 5, 2012 at 11:41 pm

    #1566016

  • RE: Mirroring: revert principal database from snapshot

    F. Dwarf (12/5/2012)

    I have to run a script against a database, and my usual backout strategy would be to take a database snapshot and revert the database from it in...

    December 5, 2012 at 12:18 pm

    #1565888

  • RE: move db files to another directory

    sqlfriends (12/5/2012)

    Thanks, but it seems detach and attach is easier and involves less steps to do.

    Do whatever you feel comfortable with, just know that in SQL server 2005 on ALTER...

    December 5, 2012 at 12:16 pm

    #1565887

  • RE: move db files to another directory

    they both achieve the same result. Detaching removes the database from the system catalogs whereas offline doesn't.

    December 5, 2012 at 10:03 am

    #1565841

  • RE: Filegroup and number of files per FG questions - Redesign of 2 TB DB with 2,000+ batches per second

    Jeff Kelly-310227 (12/5/2012)

    Are there a recommended number of files per Filegroup –some mathematical formula to # of cores/etc…?

    We understand that typically multiple files are used to spread out the...

    December 5, 2012 at 9:23 am

    #1565815

  • RE: SQL Server index fragmentation is high after rebuilt

    Bhuvnesh (12/5/2012)

    with 0 or 100 fillfactor ..more space is required and IO also get affected)

    You cannot specify a fillfactor of 0 in the rebuild command, any attempt to do so...

    December 5, 2012 at 7:02 am

    #1565743

  • RE: Reduce size of BAK file after deleting database table records?

    craig.dixon (12/5/2012)

    Good Morning Leo,

    Thanks for the reply 🙂 When taking the backups, in the overwrite media section, I have selected to "Back up to the existing media set" and the...

    December 5, 2012 at 4:42 am

    #1565676

  • RE: SQL Cluster question

    Mh-397891 (12/5/2012)

    1. Remove the SQL 2008R2 from Cluster1\Node1

    You don't need to retain any databases from here then??

    Mh-397891 (12/5/2012)

    2. Install SQL 2012 in Cluster1\Node1 along with SP1

    Why when you already have...

    December 5, 2012 at 4:38 am

    #1565674

  • RE: Failover Problem

    If the principal is down and you want to bring the mirror up you will need to force service using

    ALTER DATABASE mydb SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

    December 5, 2012 at 2:56 am

    #1565633

  • RE: ADD drive in sql cluster dependency

    you'll need to offline the SQL Server clustered service resource, then add the dependency, the bring the resource online.

    Ensure you add the stoarge to all required cluster nodes and add...

    December 5, 2012 at 2:51 am

    #1565632

    • Viewing 15 posts - 4,486 through 4,500 (of 9,253 total)