Viewing 15 posts - 181 through 195 (of 283 total)
Not sure if you can turn 2 separate servers into a cluster from a Windows level. But from a SQL level you need to install SQL on top of...
March 23, 2009 at 6:47 am
I'd say the best thing to do is download the service pack and carefully read the installation instructions! We've done several service packs on clusters and standalone machines and...
March 23, 2009 at 3:24 am
You can use SQL Profiler to trace what queries (and more) are happening against a database. You can also add filters to the trace so that only the data...
March 23, 2009 at 3:05 am
There is no guarantee with a SELECT from a table that it will show data in any particular order. The only guaranteed way is to put an ORDER BY...
March 20, 2009 at 6:32 am
The user Scott is a demo user with low privileges. You need to log in as system or sys to create a new user.
March 19, 2009 at 2:16 am
There are no fixed limits on mirroring, it depends on your network and the activity on the databases. A general recommendation is around the 10-20 database mark but it...
March 18, 2009 at 8:18 am
In that case in the event of the active server going down you can point the passive server to the disks containing the data. Have you considered mirroring?
March 18, 2009 at 6:45 am
Not sure what you are asking. If you have a cluster the shared disk will automatically switch to the standby server. If the standby server is not available...
March 18, 2009 at 3:56 am
Sounds like the date formats are incorrect and what the database thinks is the month in the table2 comparison is bigger than 12 so it can't process it. Is...
March 18, 2009 at 3:47 am
OK, maybe I didn't read the question properly. Normally you would install SQL Server on the new server and then copy only the USER databases across. The maintenance...
March 6, 2009 at 1:18 am
Getting a database into the clustered instance is the same as it would be on an unclustered instance. Jagadishrashmi has listed various methods of moving/copying a database. ...
February 20, 2009 at 1:28 am
I find that by finding out what sql/commands the GUI is running I am able to understand how new features work. I can use profiler to trace it or...
February 13, 2009 at 3:26 am
You can use SSMS to administer the clustered SQL Server instance in the normal way. To administer the actual cluster you use cluster administrator. SQL installs as a...
February 12, 2009 at 12:00 pm
The structure of the data files are the same between 32 bit and 64 bit so they can be copied via backup/restore or attach/detach.
February 11, 2009 at 11:16 am
Install the management tools part of the service pack on all nodes, these are not part of the clustered environment
February 6, 2009 at 7:08 am
Viewing 15 posts - 181 through 195 (of 283 total)