Forum Replies Created

Viewing 15 posts - 7,306 through 7,320 (of 9,241 total)

  • RE: Creating A SQL Server 2008\2008 R2 Failover Cluster

    Chris Mathews (1/20/2011)

    Anyone have any strong opinions(pro or con) about using mount points for drives? Example:G: has programs, G_01(mount_point) data, G_02 (mount point) logs. The two mount points...

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

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

    January 21, 2011 at 2:42 am

    #1276431

  • RE: Automate restores on another server

    Once you have the backup file you want to restore perform a filelistonly restore to get the filenames and logical names. Use these to restore the database.

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

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

    January 20, 2011 at 3:04 pm

    #1276271

  • RE: SQL SERVER SERVER SIDE TRACE

    my guess is your trace create script looks like this

    sp_trace_create @TraceID output, 0, N'InsertFileNameHere', @maxfilesize, NULL

    It hits the max file size but does not rollover, it should look like this

    sp_trace_create...

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

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

    January 20, 2011 at 4:52 am

    #1275794

  • RE: Automate restores on another server

    you could mirror your server builds so disk allocations are always the same, this is the practice most would follow across a SQL Server farm. Other than that, use an...

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

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

    January 20, 2011 at 4:43 am

    #1275789

  • RE: SQL server Full Backup

    techzone12 (1/19/2011)

    I noticed that there is a utility called "Windows Server Backup" that comes with the SQL server OS.

    The Windows server backup product built in to Windows 2008 is...

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

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

    January 20, 2011 at 4:40 am

    #1275786

  • RE: Adding a new FILEGROUP to an existing mirrored database

    You should be able to add files to a mirror session, there are some warnings though

    From SQL Server BOL

    :exclamation: Important

    Adding a file during a mirroring session without impacting...

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

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

    January 20, 2011 at 4:30 am

    #1275784

  • RE: Creating A SQL Server 2008\2008 R2 Failover Cluster

    TurnerC (1/19/2011)

    Hello,

    Can I receive a copy of the VMWare Server\SQL Server 2008 install.

    Currently our site has a clustered 2008 R2 sql server instal built by a third party vendor...

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

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

    January 20, 2011 at 4:04 am

    #1275776

  • RE: Creating A SQL Server 2008\2008 R2 Failover Cluster

    GRE (Gethyn Ellis) (1/19/2011)

    Perry

    Does your tutorial cover setting up the cluster on VMware workstation 6.5? if it does please can I take a peek please.

    Thanks

    Gethyn

    Hi Gethyn

    yes Workstation will be fine...

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

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

    January 20, 2011 at 3:59 am

    #1275772

  • RE: Creating A SQL Server 2008\2008 R2 Failover Cluster

    alen teplitsky (1/19/2011)

    i believe it's because you had to add it as a dependency to the SQL service.

    yes, i'm with you now that's quite correct you add the disk as...

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

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

    January 19, 2011 at 12:44 pm

    #1275521

  • RE: Creating A SQL Server 2008\2008 R2 Failover Cluster

    alen teplitsky (1/19/2011)

    and one other point, adding new drives to a cluster is another pain in the *****. you have to take the entire instance down to add a new...

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

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

    January 19, 2011 at 11:33 am

    #1275475

  • RE: Creating A SQL Server 2008\2008 R2 Failover Cluster

    alen teplitsky (1/19/2011)

    another plus is that windows clusters are a pain in the *** and changing minor things like IP's can break them.

    changing the IP for what a clustered resource...

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

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

    January 19, 2011 at 10:58 am

    #1275442

  • RE: Creating A SQL Server 2008\2008 R2 Failover Cluster

    george sibbald (1/19/2011)

    Perry,

    maybe it is taken as read but it should be mentioned another drive would be needed to install SQL application files to (i.e. the instance root directory) and...

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

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

    January 19, 2011 at 10:56 am

    #1275439

  • RE: Creating A SQL Server 2008\2008 R2 Failover Cluster

    reuben.anderson (1/19/2011)

    We're undergoing an enterprise consolidation and virtualisation project at the moment, and I currently have an external consultant proposing to replace our physical, clustered SQL Servers, with non-clustered VM's...

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

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

    January 19, 2011 at 10:48 am

    #1275434

  • RE: Creating A SQL Server 2008\2008 R2 Failover Cluster

    BigSam (1/19/2011)

    What edition of Windows & SQL does this article relate to? I would assume Windows Enterprise due to limitations on memory with Standard edition. Will this 3 node solution...

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

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

    January 19, 2011 at 7:30 am

    #1275305

  • RE: What do i need permession for system table ?

    Fish Man (1/16/2011)

    Thanks for Perry Whittle

    I will try it.

    thank you very much.

    🙂

    You will need your database administrator to grant this permission for you.

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

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

    January 16, 2011 at 9:11 am

    #1273985

Viewing 15 posts - 7,306 through 7,320 (of 9,241 total)