Viewing 15 posts - 7,741 through 7,755 (of 9,244 total)
you're welcome friend!
If you're on LinkedIn join my network and maybe recommend me if you can!
Regards
Perry
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2010 at 9:22 am
could you post the output of the following queries when run against your database
select distinct sp.name, sp.sid from sys.server_principals sp, sys.database_principals dp
where sp.type = 'S'
and not exists (select sid...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2010 at 9:21 am
Using truncateonly will shrink the file to the last used extent
DBCC SHRINKFILE (LogicalFileName, truncateonly)
Specifying a size will shrink and re arrange the file to free potentially more space (2GB in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2010 at 8:51 am
personally i would use the same file size, or maybe just one slightly smaller about 2048 MB minimum. The local controller will not have the overhead of the storage network...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2010 at 8:24 am
Hawkeye_DBA (8/20/2010)
try to run EXEC sp_change_users_login Auto_Fix, 'username'
that's because you have some parameters missing. if autofixing the database user account you need to supply a password and null for the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2010 at 8:20 am
After deploying a clustered SQL Server instance I always check my resource dependencies.
😎
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2010 at 7:03 am
On a Windows 2008 cluster the install will default to an MNS quorum configuration. You have to actually force it to use a disk which is no longer recommended. You...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2010 at 2:08 am
Mani
On the cluster node go into Failover Cluster Manager and at the top of the treeview underneath where it says "failover cluster manager" click on the Windows cluster name.
The centre...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2010 at 1:31 am
Mani-584606 (8/19/2010)
Could you please provide me the screen shot where the SQL Server 2008 installation gives the option for selecting the Quorum drive?
It doesnt, the quorum is part of the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2010 at 4:15 pm
quorum will be present as part of the cluster deployment.
Create a DTC clustered application first and then install SQL server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2010 at 12:24 pm
SQL_Padre (8/19/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2010 at 12:04 pm
onlo (8/18/2010)
and re-started the service.
you have to reboot the server, this is an operating system policy which will be forced by a reboot. Service restart has no effect!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2010 at 11:58 am
exec sp_change_users_login 'report'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2010 at 11:53 am
make sure the size of your test file is larger than the SAN cache by at least 2 x
Param file should be something like
F:\testfile.dat 2 0x0 4096
Check the Microsoft document...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2010 at 11:47 am
you should already have some sort of quorum in force even on the single node cluster.
Create a clustered DTC application and then install SQL Server failover cluster.
The necessary groups, IP...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2010 at 11:43 am
Viewing 15 posts - 7,741 through 7,755 (of 9,244 total)