One more issue, the port might have to be opened on the firewall.

-SQLBill

I can't say which one to use, but make sure it's above 1023 (I believe that's the end of the 'commonly used' Ports).

There's one big issue with changing ports, how...

You say:

I tried running the same command on the same database restored as TEST_database and the log file only jumped to 700 MB.

But was that a restore of the database from before...

What are you backing up to and how is it configured to the cluster?

When I had an active/passive cluster, I backed up to a tape library. The tape library was...

I sometimes see this with my user databases if SQL Server is shutdown with users still connected.  All I do is detach and attach the database and everything is fine.

-SQLBill

One possible problem...SQL Server instances do not like being installed on a new SQL Server that doesn't have the same patch level. Since the original instance had no service pack,...

Two questions, based on this statement:

WARNING: problem activating all tempdb files.  See previous errors.  Restart server with -f to correct the situation.

1. were any of the tempdb files...

You say it failed, but not how....

I'm guessing it's because you got slants instead of hyphens....

Use style 110......

-SQLBill

Let's see, I had a two node active/passive cluster with a SAN.

1 IP for Node 1

1 IP for Node 2

1 IP for the SAN (this was the virtual SQL Server...

194 RTM means there aren't ANY service packs applied.

Download SP3a from Microsoft's website, read the install directions and apply it. You will have to give the SA account a strong...

Nobody really answered your question, so here goes...refer to the BOL for CONVERT.

Run this:

SELECT GETDATE(),

  CONVERT(VARCHAR(20), GETDATE(), 101)

The BOL, under CONVERT shows the different STYLE codes (that's what the 101...

Are you backing up the 'backup file' to tape? Could something else be accessing the network backup file in between the job steps? Are you running an antivirus program on...

Run this via Query Analyzer:

SELECT ServerProperty('ProductVersion'),

           ServerProperty('ProductLevel')

I'll bet it will return 8.00.311 and SP1.

I suggest you download and install SP3a for SQL Server. That might help solve your problem. (SQL...

As for your error message....

Searching the BOL under "full-text queries-overview",  I found that words like "a", "the", "and" are IGNORED. So, it might be that a part of the where...

Note: I installed SP4 yesterday, but it doesn't show up here.

Yes it does...

Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)   May  3 2005 23:18:38   Copyright (c) 1988-2003 Microsoft Corporation ...