you're welcome friend!

If you're on LinkedIn join my network and maybe recommend me if you can!

Regards

Perry

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...

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...

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...

that's because you have some parameters missing. if autofixing the database user account you need to supply a password and null for the...

After deploying a clustered SQL Server instance I always check my resource dependencies.

😎

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...

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...

It doesnt, the quorum is part of the...

quorum will be present as part of the cluster deployment.

Create a DTC clustered application first and then install SQL server

SQL_Padre (8/19/2010)

---

I am need of some advise. I have a 3 node cluster, 2 Active one Passive. Server boxes have 48GB RAM, each SQL instance Min/Max is set...

you have to reboot the server, this is an operating system policy which will be forced by a reboot. Service restart has no effect!

exec sp_change_users_login 'report'

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...

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...