Just a Correction in the above query.

select distinct trace_event_id, e.name

from ::fn_trace_geteventinfo(1) t join sys.trace_events e

on t.eventid = e.trace_event_id

t.event_id is actually t.eventid

Obviously..

You should backup your database either be it User defined or system defined and that too on the different drives.

Thanks a lot to Shankar.. 🙂

@paul-2

Ans 1 : Client is looking for Consolidated Application which will be access by both the sites.

Ans 2 : did not got what exactly u r trying to...

What is MS Dynamics GP ?

@bsegermeister,

You do not have to reboot the active node to failover the services ( sql instance).

THis is better explained by Tara Kizer.

@perry

Correctly said.

In SQL 2008, you have to do SQL Installation on each node.

Database mirroring endpoints also shows important information about mirroring

select * from sys.database_mirroring_endpoints

SQL DBA + Clustering + PA + SSIS is a good combination.

The Support files are getting installed on C Drive only.

I have done 2 installation to verify this.

If you are installing SQL 2nd time on the same node, the support files...

There should be seperate Service account ( startup account) for Each SQL server Instance.

Also, that started account should be having local admin accounts on all nodes.

Even i am getting the answer as "-1, 0, 1".

I have executed the query in SQL 2008 Enterprise edition.

i am agreeing with others about the fact that

to get ans as...

Try this.

select a.name as [Table Name], b.name as [Index Name],

b.type_desc from sys.tables a, sys.indexes b

where a.object_id = b.object_id

and a.name=' Type the table name here'

( Runs on SQL 2005 /...

@vijay-2

That would be great if you share that script. It will help out lot of people.

@klnsuddu ,

you can compare the database login between SQL 2005 and SQL 2008.

Also, as a end step, you should take a backup of Database in sql 2008.