Viewing 15 posts - 7,456 through 7,470 (of 9,253 total)
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...
November 1, 2010 at 6:25 am
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...
November 1, 2010 at 3:26 am
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...
November 1, 2010 at 3:18 am
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...
October 31, 2010 at 11:48 am
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!
October 31, 2010 at 6:57 am
Also, make sure the SQL Server instance has permissions on the location you are moving the file to!!
October 31, 2010 at 5:13 am
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...
October 31, 2010 at 4:49 am
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...
October 31, 2010 at 3:55 am
Yes, which service pack do you intend to install?
October 31, 2010 at 2:30 am
I have seen these issues before along with the SKU invalid error (appears when you try to add a node!).
Slipstream the service pack during install to overcome these issues with...
October 30, 2010 at 4:42 pm
pinnamaneni.pavani
could you provide info from the cluster.log
October 30, 2010 at 4:09 pm
Jeff
There isn't really any hard fast link for a fix, it depends what the failure is. Each situation is taken on it's own merit.
For instance something I have seen a...
October 30, 2010 at 8:18 am
I always backup system databases once a day, for the size of them it's really no great shakes!
October 30, 2010 at 3:02 am
This is quite worrying too
SQL Server error log
October 30, 2010 at 2:55 am
nekonecny (10/28/2010)
SQL server take more RAM, if SQL sever need it.[p]But You can set: [/p]
[p]sp_configure 'max server memory (MB)',6144;[/p]
[p]sp_configure 'min server memory (MB)',6144;[/p]
[p]reconfigure with override[/p]
Don't forget you will also need...
October 30, 2010 at 2:48 am
Viewing 15 posts - 7,456 through 7,470 (of 9,253 total)