tblMashedUp

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

Clustering

convert stand alone sql server to cluster

I would like to know the answer for the following question for sql7, 2k, 2k5
and 2k8.
Can you convert a stand alone sql server to a node, either as first node or
second node in a active/passive cluster?
I understand that i can always build the cluster from scratch by installing
everything afresh.

4/25/2010 11:19:01 PM

NNTP Clustering

convert stand alone sql server to cluster

I would like to know the answer for the following question for sql7, 2k, 2k5
and 2k8.
Can you convert a stand alone sql server to a node, either as first node or
second node in a active/passive cluster?
I understand that i can always build the cluster from scratch by installing
everything afresh.

4/25/2010 11:19:01 PM

NNTP Replication

Purpose of the In and Out files

Hi Folks,
I am new to using SQL Server replication and I was wondering if
someone could explain or point me in the right direction for an
explanation of In and Out files which appear and disappear when
performing a sync?
Many thanks,
Morris

4/25/2010 1:32:59 PM

NNTP Replication

TableDiff Missing

The BOL documentation indicates that the TableDiff.exe is installed at
"<drive>:\Program Files\Microsoft SQL Server\100\COM". I have installed SQL
Server 2008 and SQL Server 2008 R2 and found that the TableDiff.exe was not
installed in the specified location. I am an author of a SQL Server
technical book and I want to make sure that my readers can find this useful

4/25/2010 12:50:01 PM

NNTP Clustering

multi node active/active/active/active cluster

In a hypothetical scenerio:
I want 4 node, active/active/active/active cluster.
There are 4 sql instances installed on each node, with name SQLInstance1....
SQLInstance4
My questions:
1) Can I use just one virtual name, for example SQLVirtualServer and clients
can access sql instances in format SQLVirtualServer\InstnaceName? Or Do I

4/24/2010 3:15:01 PM

Clustering

multi node active/active/active/active cluster

In a hypothetical scenerio:
I want 4 node, active/active/active/active cluster.
There are 4 sql instances installed on each node, with name SQLInstance1....
SQLInstance4
My questions:
1) Can I use just one virtual name, for example SQLVirtualServer and clients
can access sql instances in format SQLVirtualServer\InstnaceName? Or Do I

4/24/2010 3:15:01 PM

NNTP Clustering

SQL restarts itself

We have SQL 2008 64-bit running on Windows 2003 R2 64-bit. It is setup as an
Active/Active cluster. On the secondary(less used) node, SQL will restart 3
or 4 times a day. No warnings in the Event Log or SQL log. In the Event
Log, the message is categorized as a Failover message. However, it doesn't

4/23/2010 9:30:06 PM

Clustering

SQL restarts itself

We have SQL 2008 64-bit running on Windows 2003 R2 64-bit. It is setup as an
Active/Active cluster. On the secondary(less used) node, SQL will restart 3
or 4 times a day. No warnings in the Event Log or SQL log. In the Event
Log, the message is categorized as a Failover message. However, it doesn't

4/23/2010 9:30:06 PM

NNTP Replication

How to get data out of Access MDE files?

Dear Experts,
I have an application that I've used for years
that runs on Access under the covers. Help shows
a reference to:
Access 2002 Desktop Developer's Handbook
It was a self contained application.
All I have are the two MDE files.
And they are full of data now.
The app requires a login.
I want to export this data into another database.

4/23/2010 7:37:50 PM

NNTP Connect

SQL Server Express

How to uninstall SQLEXPRESS? It is not in Add/Remove Program and also it did
not work from command prompt:
CD %ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\Release
setup.exe /ACTION=uninstall /FEATURES=Feature_List /INSTANCENAME=Instance_Name
%ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\Release directory

4/23/2010 6:18:01 PM

NNTP Replication

Merge replication problem - 3rd attempt to post

I'm using merge replication to get information to and from field
engineers, which has worked fine until recently.
Now, when any of the engineers try to replicate, the following error
occurs :
The Merge Agent failed because the schema of the article at the
Publisher does not match the schema of the article at the Subscriber.

4/23/2010 1:33:17 PM

NNTP Replication

Merge replication problems

I'm using merge replication to get information to and from field
engineers, which has worked fine until recently.
Now, when any of the engineers try to replicate, the following error
occurs :
The Merge Agent failed because the schema of the article at the
Publisher does not match the schema of the article at the Subscriber.

4/23/2010 1:25:54 PM

NNTP Connect

SQL Server 2008 does not autostart

I recently recovered from a crash with what I hope is minor registry damage.
SQL Server does not startup with the computer and the Service has
disappeared from Administrative Tools->Services.
If I start SQL Server from sqlservr.exe then the service starts, recovers
databases and can be accessed normally both locally and remotely. The

4/22/2010 2:28:02 PM

NNTP Replication

Merge replication error

I'm using merge replication to get information to and from field
engineers, which has worked fine until recently.
Now, when any of the engineers try to replicate, the following error
occurs :
The Merge Agent failed because the schema of the article at the
Publisher does not match the schema of the article at the Subscriber.

4/22/2010 10:42:12 AM

NNTP Connect

domain group login can't login

sql 2008 sp1
domain user [Domain\SpecificUser] is a member of domain group
[Domain\SomeGroup].
If I add a login for [Domain\SpecificUser] with the proper security settings
on databases everything works correctly. If I add login for
[Domain\SomeGroup] with the same settings I get... Error: 18456, Severity:

4/20/2010 11:44:01 PM

1 2 3 4 5 6 7 8 9 10
11 12 13 14 15 16 17 18 19 20
21 22 23 24 25 26 27 28 29 30
31 32 33 34 35 36 37 38 39 40
41 42 43 44 45 46 47 48 49 50
51 52 53 54 55

pBlogCategories

sys.books