Forum Replies Created

Viewing 15 posts - 7,441 through 7,455 (of 9,244 total)

  • RE: Log shipping question

    SqlN00bie (11/1/2010)


    I have created a script to do the log backup for multiple databases instead of using the log-shipping wizzard. This is just so i have less number of...

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

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

  • RE: SSRS install process

    Parthi

    see the attachment below for my instructions on how to configure an SSRS 2008 instance

    😎

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

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

  • RE: sql account with connect sql can shutdown sql server

    have you checked the local administrators group on the server?

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

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

  • RE: SSRS install process

    Adiga (11/1/2010)


    Here is the official documentation on how to Install SSRS.

    That link covers SQL Server 2005 not 2008!

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

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

  • RE: SQL Server 2008 Setup Hangs

    romil

    which edition of SQL server 2008 are you installing?

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

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

  • RE: SSRS install process

    which part exactly are you stuck on? I have some configuration instructions if required. SSRS does not actually use IIS any longer although it does still use the kernel mode...

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

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

  • RE: Trying to get hands on experience on failover clustering. Please suggest.

    mohammed moinudheen (11/1/2010)


    Thank you Perry. I will try this out and revert to the forum for further queries.

    Obviously if using the Windows 2008 Eval edition you will have to rebuild...

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

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

  • RE: Trying to get hands on experience on failover clustering. Please suggest.

    mohammed moinudheen (10/31/2010)


    Is there anyway we could try clustering on a windows 7 machine just for learning purpose.

    Please advise.

    Use the Windows 2008 R2 OS for your host machine, VMWare Server...

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

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

  • RE: Trying to get hands on experience on failover clustering. Please suggest.

    Henrico Bekker (10/31/2010)


    You need an OS with Cluster support, Server 2003 or 2008 would be best to test.

    Mohammed's current issue is regarding the virtual machine host OS not the cluster...

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

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

  • RE: Trying to get hands on experience on failover clustering. Please suggest.

    Check the VMWare Server user's guide for details of supported host OS's. I have successfully used Windows XP Pro SP2, however I dont think Windows 7 is supported and certainly...

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

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

  • RE: Move MDF file to new Drive

    also, you don't need to restart the sql server sevices when changing a database file location with alter database, the offline\online will be sufficient!

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

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

  • RE: Move MDF file to new Drive

    Also, make sure the SQL Server instance has permissions on the location you are moving the file to!!

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

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

  • RE: Move MDF file to new Drive

    correct sequence is;

    1. ALTER DATABASE TEST MODIFY FILE (NAME = test, FILENAME = 'F:\SQL data\test.mdf')

    2. bring DB offline

    2. Copy MDF file to new Drive

    3. Bring Db online.

    Did copy the file...

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

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

  • RE: SQL2K8 Cluster Installation Error

    to slipstream Service pack 1 do the following;

    ➡ Ensure you have SP2 installed for Windows 2003

    ➡ install .NET 3.5 framework (on the dvd image)

    ➡ install Windows Installer 4.5 (on the...

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

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

  • RE: SQL2K8 Cluster Installation Error

    Yes, which service pack do you intend to install?

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

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

Viewing 15 posts - 7,441 through 7,455 (of 9,244 total)