Hi,

I am sorry you can install more than one instance in the same drive and in the same directory (for example program files). When installing the instance you choose a...

hi,

I used the attached script to check space.

Regards

Ahmed

Hi massawa,

The only thing the Principal and the 2 others must be on differents drives.

I assume the C drive contains the operating system.

The SQL Server default instance ?

Regards,

Ahmed

Hi massawa,

Yes you have to install two other named instances.

If you want, You can install all instances in the same drive.

Let us install the witness and the mirror on...

Hi Mr Salah,

I forget to tell you that your goal is to have High availability.

It means to have the failover.

If it's me for a production database, I will uses 3...

Hi Mr Salah,

ASMARINO is the name of the computer and the name of the default instance of the SQL Server.

The witness, principal and mirror should be on different instances (If...

Hi,

I am sorry Vyas find another way 😛

Regards,

Ahmed

Hi Salah,

I am sorry for the delay, it's 5:25 Am (here). You should install the mirror and witness before starting the mirroring (3 differents instances)

The witness server's role is to...

Hi Simons,

the only way is to use a cursor or the the code below.

INSERT INTO Table1 (CustID, CustName)

SELECT DISTINCT CustID, CustName

FROM ##TThird T1

WHERE CustName=(SELECT top 1 CustName FROM ##TThird T2...

hi,

I already did it on production server, you need to be careful. (it could take a long time a couple of hours, but if you are well organized it just...

Hi,

As Kumar said you need to rebuild system databases to change collation (in SQL 2000 you need just to Rebuild Master in 2005 the way to rebuild master has changed).

Check...

Hi,

I think in the begining you cannot do something (only if you know the volume/frequency of transactions

insert/delete/update :)) to figure out the file growth of your database but...

Hi,

You can also use the OPENROWSET wich is an alternative to accessing tables in a linked server.

Checkthe following link

http://msdn2.microsoft.com/en-us/library/aa276850(SQL.80).aspx

Regards,

Ahmed

Hi Megha,

Check the following links :

1- Use of SCHEMABINDING option for TSQL UDFs can improve performance in SQL Server 2005

http://blogs.msdn.com/sqltips/archive/2006/06/12/628722.aspx

http://blogs.msdn.com/sqlprogrammability/archive/2006/05/12/596424.aspx

SQL Server 2005 has new optimization logic to use the SCHEMABINDING...

hi,

like Greg said the miror database will have the state restoring (wiating transaction logs from the principal).

Regards,

Ahmed