Forum Replies Created

Viewing 15 posts - 5,266 through 5,280 (of 9,253 total)

  • RE: Setting up log shipping for multiple databases

    stephen.chapman 77519 (7/24/2012)

    Hi,

    I am new to this forum but I have just had to deal with setting up log shipping for a DR site which would have meant setting this...

    July 24, 2012 at 4:58 am

    #1516715

  • RE: Configuration for SQL Server 2012

    sixthzenz (7/23/2012)

    I'm building a dev server for our team and the drives are currently configured as follows:

    One 240GB SSD (Use it for the OS only?)

    One 220 GB SSD RAID 10...

    July 24, 2012 at 3:36 am

    #1516679

  • RE: huge unsent log in DB mirroring

    winston Smith (7/24/2012)

    I have two databsaes in async mirroring. Today there was a massive value for unsent log (it was showing over 50GB) and a time to send log at...

    July 24, 2012 at 2:54 am

    #1516654

  • RE: Diverting clinet network traffic form primary server to secondary server in case of log shipping

    anoop.mig29 (7/23/2012)

    hi we are trying to carry out log shipping in sql server 2008 enterprise edition.problem is how to divert client traffic form primary server to secondary server once we...

    July 24, 2012 at 2:53 am

    #1516653

  • RE: To Insert rows into a Compressed table..

    Jayanth_Kurup (7/23/2012)

    There is a CPU overhead with compression, since your inserting thousands of rows , make sure you take this into account. other than this there is nothin special needed...

    July 24, 2012 at 2:49 am

    #1516651

  • RE: SQL Server 2012 Cluster licensing

    rummings (7/23/2012)

    I read that to use "Always On"... you need to run SQL Server 2012 Enterprise Edition. We were considering going to three Virtual Servers for the new cluster.

    yes AO...

    July 23, 2012 at 3:02 pm

    #1516489

  • RE: Suspect Database

    farushaik (7/23/2012)

    Anthony,

    I was following that process. But the database doesn't change to single user mode for some reason.

    I think I'll have to go for restoring from the backup ..

    see my...

    July 23, 2012 at 7:26 am

    #1516219

  • RE: Suspect Database

    farushaik (7/23/2012)

    Msg 5282, Level 16, State 2, Line 1

    Table error: Object ID 706101556, index ID 2, partition ID 72057597246242816, alloc unit ID 72057597500653568 (type In-row data), page (38175:9). The...

    July 23, 2012 at 7:25 am

    #1516216

  • RE: Starting SQL services - Best practise

    SQLCrazyCertified (7/23/2012)

    So, I would say best practice is to stop/start SQL from Configuration Manager.

    Or failover cluster manager if it's a clustered instance of SQL Server

    July 23, 2012 at 7:18 am

    #1516212

  • RE: 2008 LogShipping - Files deleted before copy

    Ferguson (7/23/2012)

    My DBA brought me a problem that was very surprising. We had a log shipping secondary down for maintenance, and while it was down the retention period of...

    July 23, 2012 at 7:16 am

    #1516208

  • RE: Moving LUN's from existing server to new cluster

    Most SAN\NAS technologies will allow you to mask off LUNs from one host and attach to another. However, it may be better to mirror the current LUNs to new LUNs...

    July 23, 2012 at 7:09 am

    #1516206

  • RE: DBCC Hangs

    Stamey (7/23/2012)

    I left it to run all weekend and it turns out it only ran 4:41.00. Is CheckDB cumulative, in that whatever it did before is saved and it continues...

    July 23, 2012 at 6:12 am

    #1516175

  • RE: Concurrency question

    the only concurrency issue you're likely to get is if someone is updating the table at the time you request the reads

    July 23, 2012 at 6:09 am

    #1516172

  • RE: DBO permissions to a user

    Just seen this post but need to clarify.

    There is a difference between the user\schema dbo and the database role Db_Owner.

    A user who is the owner of a database will map...

    July 23, 2012 at 5:59 am

    #1516168

  • RE: AlwaysOn Availability Group Restore

    santosh.balaraj (7/23/2012)

    I am writing a program to restore a Database which is part of a AAG group.

    What are you trying to restore, the primary or a replica database?

    santosh.balaraj (7/23/2012)

    The...

    July 23, 2012 at 5:46 am

    #1516159

Viewing 15 posts - 5,266 through 5,280 (of 9,253 total)