Forum Replies Created

Viewing 15 posts - 6,196 through 6,210 (of 9,241 total)

  • RE: Microsoft Sql server standard download

    The Enterprise eval is for exactly that, not for testing your apps\software releases. I'm sure that's in the EULA somewhere!!

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

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

  • RE: Prune backups to last Full and subsequent transaction backups

    Chrissy321 (12/13/2011)


    I have xp_cmdshell available on this server

    No xp_cmdshell, just execute the vb script from a SQL server agent job step

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

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

  • RE: Installing 2008 instance on 2005 box

    homebrew01 (12/12/2011)


    I want to install an instance of 2008 R2 on my development box that already is running 2005. Any suggestions or best practices for locating/naming folders, files, defaults etc.....

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

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

  • RE: Moving large files/backups across data centers.

    Tristan Chiappisi (12/13/2011)


    Hello,

    I'm looking for a solution for moving large files across data centers (in the sense of making it faster). Has anyone had much luck with any programs out...

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

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

  • RE: Microsoft Sql server standard download

    vkr.karthick (12/13/2011)


    I need to install Microsoft Sql standard R2 Sp1 64 bit version for my testing can anyone send a link

    I tried download from Microsoft site but could do only...

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

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

  • RE: How long should a shrink take

    it all depends on which other options you selected in the GUI, for instance did you elect to "reorganise pages before releasing unused space"?

    Remember to leave enough free space...

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

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

  • RE: Prune backups to last Full and subsequent transaction backups

    better option would be to use scripted T-SQL jobs, the BACKUP DATABASE command has a MIRROR TO clause which can be used to mirror backups. A lightweight VB script can...

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

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

  • RE: Log shipping SQL 2008 from SQL 2008?

    this question has been raised before, yes it is possible but there are caveats around it

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

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

  • RE: Using and Creating Mount Points in SQL Server

    Hi sorry, my bad totally missed the cluster part. Yes for a new clustered instance you will need to add another root drive and letter to the new application group

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

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

  • RE: Using and Creating Mount Points in SQL Server

    kellithompson (12/9/2011)


    My question is when I am ready to install a new instance (let's call it WebDev), can I use the existing WebProd drive letter and mount some additional volumes...

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

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

  • RE: Using FILEGROUP / files in a multi customers databases

    Pierre Boucher (12/8/2011)


    - Should I allocate multiple files for each FILEGROUP so that our SAN can distribute the I/O?

    It's not a given, and in fact for user databases...

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

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

  • RE: delete .ldf files

    if you only want to keep one log file you dont have a choice which one, you must keep the log file with file id of 2, delete all others...

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

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

  • RE: Install SQL Server 2008 R2 failover cluster with MSDTC

    Here's the MS resource for Windows 2008 MSDTC

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

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

  • RE: Install SQL Server 2008 R2 failover cluster with MSDTC

    its no longer enforced but i implement it for the following reason

    you have NodeA and NodeB and the clustered sql server instance uses the virtual network name CLUSNODE1, it is...

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

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

  • RE: LiteSpeed command line to perform the restore

    if you're unsure then open the Litespeed console and step through the backup or restore process for your chosen database. At the end of the wizard, before executing, there is...

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

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

Viewing 15 posts - 6,196 through 6,210 (of 9,241 total)