Forum Replies Created

Viewing 15 posts - 6,916 through 6,930 (of 9,244 total)

  • RE: Help for rebuild index

    subbkarth (7/14/2011)


    In one of my production server scheduled a maintenance plan for rebuild index on 1 am.

    suddenly i'm getting this error:

    Here is the error

    Executing the query "ALTER INDEX [work_package_calendar_work_package_IDX] ON...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Truncating transaction log

    GilaMonster (7/14/2011)


    so no point in time recovery until, you take another full backup.

    or a differential 😉

    If the 2 hourly backups are not managing the log sufficiently increase it to...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Question on Database Mirrorring

    not something i have ever seen before, the databases will synchronise when they both restart.

    Build yourself a couple of virtual machines and try it 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Question on Database Mirrorring

    what issues are you expecting or considering??

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: High Memory Used in active MS SQL Clustering Server

    SQL Server buffer pool is typically the largest memory consumer, have you accounted for this?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: restarting an sql server

    thanoseft (7/14/2011)


    and i do not want it to run while i restarting

    ???????

    All operations are rolled back anyway. Do what you must but there is no need to disable the jobs...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL Server Mirroring

    garfield81 (7/13/2011)


    Planning on setting up mirroring for a SQL 2008 standard production server and I realize I need to restore the DB on the mirror server with NORECOVERY and then...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: login transfers

    this link provides full details

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Application is unable to connect to the database.

    SVR (7/12/2011)


    Hi,

    I am using sql server 2008 on win 2008. I restored a database from sql server 2000 to 2008, and also installed the application using...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: restarting an sql server

    you don't need to disable the jobs to restart the instance!!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Set recovery full for multiple database

    how many databases on the server are 90 compatibility

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Database Mirroring setup issue

    geenrally you dont want to use the sql server service account as the security principal for your endpoints. Create a base domain user, grant login to sql server and grant...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Creating a 2 Node SQL Server 2008 Virtual Cluster Part 1

    tobyteel (7/12/2011)


    Why would you want to do this? What does this achieve?

    I thought that was clear from the introduction, thanks for your feedback

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Creating a 2 Node SQL Server 2008 Virtual Cluster Part 1

    thats the latest version which i'm not using in the tutorial and there is a vast difference. try this link for v7 stable release

    http://sourceforge.net/projects/freenas/files/FreeNAS-7-Stable/[/url]

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: RAID configuration for SQL Server 2008 Database with 8 hard disks

    RAID10 can offer fast reads depending upon the controller used. Modern RAID10 arrays will read from all online disks to improve performance

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 6,916 through 6,930 (of 9,244 total)