Can't get mirroring working for all DBs?

I'm getting the following errors when trying to set up mirroring for a DB.
[PRINCIPAL]
Date 3/2/2007 2:52:06 PM
Log SQL Server (Current - 3/5/2007 8:44:00 AM)
Source spid99
Message
Communications to the remote server instance 'TCP://SQL2:5022' failed before
database mirroring was fully started. The ALTER DATABASE command failed.
Retry the command when the remote database is started.
Date 3/2/2007 2:52:06 PM
Log SQL Server (Current - 3/5/2007 8:44:00 AM)
Source spid99
Message
Error: 1413, Severity: 16, State: 1.
Date 3/2/2007 2:52:06 PM
Log SQL Server (Current - 3/5/2007 8:44:00 AM)
Source spid37s
Message
The mirroring connection to "TCP://SQL2:5022" has timed out for database
"DB1" after 10 seconds without a response. Check the service and network
connections.
Date 3/2/2007 2:52:06 PM
Log SQL Server (Current - 3/5/2007 8:44:00 AM)
Source spid37s
Message
Error: 1479, Severity: 16, State: 1.
[MIRROR]
Date 3/2/2007 2:52:49 PM
Log SQL Server (Current - 3/5/2007 8:46:00 AM)
Source spid35s
Message
The mirroring connection to "TCP://SQL1:5022" has timed out for database
"DB1" after 5 seconds without a response. Check the service and network
connections.
Date 3/2/2007 2:52:49 PM
Log SQL Server (Current - 3/5/2007 8:46:00 AM)
Source spid35s
Message
Error: 1479, Severity: 16, State: 1.
This only occurs for this particular DB. I have mirroring running
successfully for 4 other DBs. The only difference I can see is that the
problematic DB is significantly larger than the other mirrored DBs... it's
~70GB.
I'm running SQL 2005 Enterprise x64 for both principal and mirror SQL
instances.
Please help...interesting. cant say I've seen this before but trying running consistancy
check DBCC CHECKDB (refer to BOL) perhaps a corruption in the db is causing
the timeout.
M.
"slin" <slin@.discussions.microsoft.com> wrote in message
news:E52523C6-0B5C-4507-B6FA-9439EFD1C02E@.microsoft.com...
> I'm getting the following errors when trying to set up mirroring for a DB.
> [PRINCIPAL]
> Date 3/2/2007 2:52:06 PM
> Log SQL Server (Current - 3/5/2007 8:44:00 AM)
> Source spid99
> Message
> Communications to the remote server instance 'TCP://SQL2:5022' failed
> before
> database mirroring was fully started. The ALTER DATABASE command failed.
> Retry the command when the remote database is started.
> Date 3/2/2007 2:52:06 PM
> Log SQL Server (Current - 3/5/2007 8:44:00 AM)
> Source spid99
> Message
> Error: 1413, Severity: 16, State: 1.
> Date 3/2/2007 2:52:06 PM
> Log SQL Server (Current - 3/5/2007 8:44:00 AM)
> Source spid37s
> Message
> The mirroring connection to "TCP://SQL2:5022" has timed out for database
> "DB1" after 10 seconds without a response. Check the service and network
> connections.
> Date 3/2/2007 2:52:06 PM
> Log SQL Server (Current - 3/5/2007 8:44:00 AM)
> Source spid37s
> Message
> Error: 1479, Severity: 16, State: 1.
>
> [MIRROR]
> Date 3/2/2007 2:52:49 PM
> Log SQL Server (Current - 3/5/2007 8:46:00 AM)
> Source spid35s
> Message
> The mirroring connection to "TCP://SQL1:5022" has timed out for database
> "DB1" after 5 seconds without a response. Check the service and network
> connections.
>
> Date 3/2/2007 2:52:49 PM
> Log SQL Server (Current - 3/5/2007 8:46:00 AM)
> Source spid35s
> Message
> Error: 1479, Severity: 16, State: 1.
>
> This only occurs for this particular DB. I have mirroring running
> successfully for 4 other DBs. The only difference I can see is that the
> problematic DB is significantly larger than the other mirrored DBs... it's
> ~70GB.
> I'm running SQL 2005 Enterprise x64 for both principal and mirror SQL
> instances.
> Please help...|||Already did a DBCC CHECKDB... No errors. I'm using Profiler to see if it'll
show me what's failing, but not having any luck so far...
-S
"Mark Broadbent" wrote:
> interesting. cant say I've seen this before but trying running consistancy
> check DBCC CHECKDB (refer to BOL) perhaps a corruption in the db is causing
> the timeout.
> M.
>
> "slin" <slin@.discussions.microsoft.com> wrote in message
> news:E52523C6-0B5C-4507-B6FA-9439EFD1C02E@.microsoft.com...
> > I'm getting the following errors when trying to set up mirroring for a DB.
> >
> > [PRINCIPAL]
> >
> > Date 3/2/2007 2:52:06 PM
> > Log SQL Server (Current - 3/5/2007 8:44:00 AM)
> > Source spid99
> > Message
> > Communications to the remote server instance 'TCP://SQL2:5022' failed
> > before
> > database mirroring was fully started. The ALTER DATABASE command failed.
> > Retry the command when the remote database is started.
> >
> > Date 3/2/2007 2:52:06 PM
> > Log SQL Server (Current - 3/5/2007 8:44:00 AM)
> > Source spid99
> > Message
> > Error: 1413, Severity: 16, State: 1.
> >
> > Date 3/2/2007 2:52:06 PM
> > Log SQL Server (Current - 3/5/2007 8:44:00 AM)
> > Source spid37s
> > Message
> > The mirroring connection to "TCP://SQL2:5022" has timed out for database
> > "DB1" after 10 seconds without a response. Check the service and network
> > connections.
> >
> > Date 3/2/2007 2:52:06 PM
> > Log SQL Server (Current - 3/5/2007 8:44:00 AM)
> > Source spid37s
> > Message
> > Error: 1479, Severity: 16, State: 1.
> >
> >
> > [MIRROR]
> >
> > Date 3/2/2007 2:52:49 PM
> > Log SQL Server (Current - 3/5/2007 8:46:00 AM)
> > Source spid35s
> > Message
> > The mirroring connection to "TCP://SQL1:5022" has timed out for database
> > "DB1" after 5 seconds without a response. Check the service and network
> > connections.
> >
> >
> > Date 3/2/2007 2:52:49 PM
> > Log SQL Server (Current - 3/5/2007 8:46:00 AM)
> > Source spid35s
> > Message
> > Error: 1479, Severity: 16, State: 1.
> >
> >
> > This only occurs for this particular DB. I have mirroring running
> > successfully for 4 other DBs. The only difference I can see is that the
> > problematic DB is significantly larger than the other mirrored DBs... it's
> > ~70GB.
> >
> > I'm running SQL 2005 Enterprise x64 for both principal and mirror SQL
> > instances.
> >
> > Please help...
>
>|||Well... I finally got it working. It seemed like the large physical size of
the transaction log file was causing the problem. The log file was 200GB,
but it was only 1% used. I shrunk the log file size back down to 1GB and did
the whole restore/backup process and mirroring started right up.
"slin" wrote:
> Already did a DBCC CHECKDB... No errors. I'm using Profiler to see if it'll
> show me what's failing, but not having any luck so far...
> -S
> "Mark Broadbent" wrote:
> > interesting. cant say I've seen this before but trying running consistancy
> > check DBCC CHECKDB (refer to BOL) perhaps a corruption in the db is causing
> > the timeout.
> >
> > M.
> >
> >
> > "slin" <slin@.discussions.microsoft.com> wrote in message
> > news:E52523C6-0B5C-4507-B6FA-9439EFD1C02E@.microsoft.com...
> > > I'm getting the following errors when trying to set up mirroring for a DB.
> > >
> > > [PRINCIPAL]
> > >
> > > Date 3/2/2007 2:52:06 PM
> > > Log SQL Server (Current - 3/5/2007 8:44:00 AM)
> > > Source spid99
> > > Message
> > > Communications to the remote server instance 'TCP://SQL2:5022' failed
> > > before
> > > database mirroring was fully started. The ALTER DATABASE command failed.
> > > Retry the command when the remote database is started.
> > >
> > > Date 3/2/2007 2:52:06 PM
> > > Log SQL Server (Current - 3/5/2007 8:44:00 AM)
> > > Source spid99
> > > Message
> > > Error: 1413, Severity: 16, State: 1.
> > >
> > > Date 3/2/2007 2:52:06 PM
> > > Log SQL Server (Current - 3/5/2007 8:44:00 AM)
> > > Source spid37s
> > > Message
> > > The mirroring connection to "TCP://SQL2:5022" has timed out for database
> > > "DB1" after 10 seconds without a response. Check the service and network
> > > connections.
> > >
> > > Date 3/2/2007 2:52:06 PM
> > > Log SQL Server (Current - 3/5/2007 8:44:00 AM)
> > > Source spid37s
> > > Message
> > > Error: 1479, Severity: 16, State: 1.
> > >
> > >
> > > [MIRROR]
> > >
> > > Date 3/2/2007 2:52:49 PM
> > > Log SQL Server (Current - 3/5/2007 8:46:00 AM)
> > > Source spid35s
> > > Message
> > > The mirroring connection to "TCP://SQL1:5022" has timed out for database
> > > "DB1" after 5 seconds without a response. Check the service and network
> > > connections.
> > >
> > >
> > > Date 3/2/2007 2:52:49 PM
> > > Log SQL Server (Current - 3/5/2007 8:46:00 AM)
> > > Source spid35s
> > > Message
> > > Error: 1479, Severity: 16, State: 1.
> > >
> > >
> > > This only occurs for this particular DB. I have mirroring running
> > > successfully for 4 other DBs. The only difference I can see is that the
> > > problematic DB is significantly larger than the other mirrored DBs... it's
> > > ~70GB.
> > >
> > > I'm running SQL 2005 Enterprise x64 for both principal and mirror SQL
> > > instances.
> > >
> > > Please help...
> >
> >
> >

Can't get it to listen on TCP port 1433

Been having SQL Server 2000 running for some time now, but recently it stopped listening on TCP port 1433, the log reports its listening on shared memory, Named pipes and Rpc, but no sign of 127.0.0.1 port 1433 or any errors to say why it won't listen.

I've done a netstat -na and nothing else is listening on that port, tried restarting using the enterprise manager, gonna try restarting the entire Server when everyone has gone home, but I'm pretty sure its been restarted recently.

All the other archive logs going back a few days show its not listening.

Yes, I have used the Server network utility to make sure TCP/IP is enabled and set to 1433, even added a comma and 1434 to see if it will listen on multiple ports, no go.

Any help?
What service pack do you have installed?|||Have you told your firewall to allow connections to Microsoft SQL Server?|||SQL Server 2000 - 8.00.194 build 3790 Service pack 1

Mmmm, isn't SP3 out?
Lets hope it doesn't break it even more, as after the restart of the entire server last night, its now not responding to TCP connections locally 127.0.0.1

Not sure about the firewall, I'll have to check, its been fine with it for the past few years.

|||

SP4 has been out for quite some time. Here is a handy web site which lists all of the hot fix and service packs which have been released http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx.

Start by upgrading to SQL 2000 SP4. Odds are a Windows 2000 hot fix shuts down SQL from talking over the net if prior to SP3 as there is a major security flaw prior to SP3 which the SQL Slammer worm expliots.

Can't get AND to work.

I have a contains string that says ' "Log In" ' which works fine and returns
results. I put in ' "Log" or "In" ' and I get results. I put in ' "Log" and
"In" ' and get "Informational: The full-text search condition contained
noise word(s)."
Any thoughts?
What I want to do is be able to have multiple terms with ands in the
expression.
TIA - Jeff.
Remove the words in from your noise word list. As you appear to be in the
States, empty the noise.enu or noiseenu.txt files and replace them with a
single space. Then rebuild your catalogs. You should be able to search on
them now.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mufasa" <jb@.nowhere.com> wrote in message
news:%23BdhgvGdHHA.4872@.TK2MSFTNGP03.phx.gbl...
>I have a contains string that says ' "Log In" ' which works fine and
>returns results. I put in ' "Log" or "In" ' and I get results. I put in '
>"Log" and "In" ' and get "Informational: The full-text search condition
>contained noise word(s)."
> Any thoughts?
> What I want to do is be able to have multiple terms with ands in the
> expression.
> TIA - Jeff.
>
|||Thanks for the help.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:O$DM0OIdHHA.208@.TK2MSFTNGP05.phx.gbl...
> Remove the words in from your noise word list. As you appear to be in the
> States, empty the noise.enu or noiseenu.txt files and replace them with a
> single space. Then rebuild your catalogs. You should be able to search on
> them now.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Mufasa" <jb@.nowhere.com> wrote in message
> news:%23BdhgvGdHHA.4872@.TK2MSFTNGP03.phx.gbl...
>
|||You're welcome.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mufasa" <jb@.nowhere.com> wrote in message
news:%23RiY9UWdHHA.4784@.TK2MSFTNGP06.phx.gbl...
> Thanks for the help.
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:O$DM0OIdHHA.208@.TK2MSFTNGP05.phx.gbl...
>
|||Hilary,
That didn't seem to work. I changed both the noise.enu and for grins the
noise.eng file to be a single space. I also regenerated the full text index.
Now if I try where contains ( webpagetext, '"IN"' ) I still get
the Informational: The full-text search condition contained noise word(s).
message.
Any thoughts?
TIA - Jeff.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23w5O$1fdHHA.2268@.TK2MSFTNGP02.phx.gbl...
> You're welcome.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Mufasa" <jb@.nowhere.com> wrote in message
> news:%23RiY9UWdHHA.4784@.TK2MSFTNGP06.phx.gbl...
>
|||Did you restart the msftesql service after updating the noise list?
Best regards,
-Denis.
"Mufasa" wrote:

> Hilary,
> That didn't seem to work. I changed both the noise.enu and for grins the
> noise.eng file to be a single space. I also regenerated the full text index.
> Now if I try where contains ( webpagetext, '"IN"' ) I still get
> the Informational: The full-text search condition contained noise word(s).
> message.
> Any thoughts?
> TIA - Jeff.
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%23w5O$1fdHHA.2268@.TK2MSFTNGP02.phx.gbl...
>
>
|||The machine has been completely rebooted, and the text index was rebuilt.
It sounds like the file was not saved correctly. But I've checked it. I've
also done a search for noise.enu and there is only one copy on the machine -
in the Windows\System32 directory.
"denistc" <denistc@.discussions.microsoft.com> wrote in message
news:38149F6E-B714-446F-B6E0-31057D7D7B71@.microsoft.com...[vbcol=seagreen]
> Did you restart the msftesql service after updating the noise list?
> Best regards,
> -Denis.
> "Mufasa" wrote:

can't drop user, owns objects

I migrated copies of a database to a test server, but I cannot log on. My
admin account needs to be dropped and readded but every time I run
sp_dropuser in query analyzer I get the error :
Msg 15183, level 16, state 1, ...
"the user owns objects in the database and cannot be dropped."
then a list of the objects (EG TMP_SYSA_1234) is displayed.
How can I delete these objects? I assume then I will be able to delete the
user and recreate him.
On 20 mar, 19:09, totoro <tot...@.discussions.microsoft.com> wrote:
> I migrated copies of a database to a test server, but I cannot log on. My
> admin account needs to be dropped and readded but every time I run
> sp_dropuser in query analyzer I get the error :
> Msg 15183, level 16, state 1, ...
> "the user owns objects in the database and cannot be dropped."
> then a list of the objects (EG TMP_SYSA_1234) is displayed.
> How can I delete these objects? I assume then I will be able to delete the
> user and recreate him.
Hi,
You're perfectly right... This error means that some objects are still
owned by this user.
In order to drop each object, you will first need to know what kind of
objects are owned by the user you would like to delete. Then, you'll
be able to run the correct drop commands in the query analyser...
As an example, here are some usual drop commands :
DROP TABLE [schema].[Table name]
DROP VIEW [schema].[View name]
DROP PROCEDURE [schema].[Procedure name]
...
Whenever all the objects owned will be dropped, you'll be able to use
the sp_dropuser procedure.
Hope this helps,
Cdric Del Nibbio
MCTS SQL Server 2005
MCSD .NET
MCT
http://cedric-delnibbio-sql.blogspot.com
|||thank you, Cedric
"Cédric Del Nibbio" wrote:

> On 20 mar, 19:09, totoro <tot...@.discussions.microsoft.com> wrote:
> Hi,
> You're perfectly right... This error means that some objects are still
> owned by this user.
> In order to drop each object, you will first need to know what kind of
> objects are owned by the user you would like to delete. Then, you'll
> be able to run the correct drop commands in the query analyser...
> As an example, here are some usual drop commands :
> DROP TABLE [schema].[Table name]
> DROP VIEW [schema].[View name]
> DROP PROCEDURE [schema].[Procedure name]
> ...
> Whenever all the objects owned will be dropped, you'll be able to use
> the sp_dropuser procedure.
> Hope this helps,
> Cédric Del Nibbio
> MCTS SQL Server 2005
> MCSD .NET
> MCT
> http://cedric-delnibbio-sql.blogspot.com
>

can't drop user, owns objects

I migrated copies of a database to a test server, but I cannot log on. My
admin account needs to be dropped and readded but every time I run
sp_dropuser in query analyzer I get the error :
Msg 15183, level 16, state 1, ...
"the user owns objects in the database and cannot be dropped."
then a list of the objects (EG TMP_SYSA_1234) is displayed.
How can I delete these objects? I assume then I will be able to delete the
user and recreate him.On 20 mar, 19:09, totoro <tot...@.discussions.microsoft.com> wrote:
> I migrated copies of a database to a test server, but I cannot log on. My
> admin account needs to be dropped and readded but every time I run
> sp_dropuser in query analyzer I get the error :
> Msg 15183, level 16, state 1, ...
> "the user owns objects in the database and cannot be dropped."
> then a list of the objects (EG TMP_SYSA_1234) is displayed.
> How can I delete these objects? I assume then I will be able to delete the
> user and recreate him.
Hi,
You're perfectly right... This error means that some objects are still
owned by this user.
In order to drop each object, you will first need to know what kind of
objects are owned by the user you would like to delete. Then, you'll
be able to run the correct drop commands in the query analyser...
As an example, here are some usual drop commands :
DROP TABLE [schema].[Table name]
DROP VIEW [schema].[View name]
DROP PROCEDURE [schema].[Procedure name]
.=2E.
Whenever all the objects owned will be dropped, you'll be able to use
the sp_dropuser procedure.
Hope this helps,
C=E9dric Del Nibbio
MCTS SQL Server 2005
MCSD .NET
MCT
http://cedric-delnibbio-sql.blogspot.com|||thank you, Cedric
"Cédric Del Nibbio" wrote:

> On 20 mar, 19:09, totoro <tot...@.discussions.microsoft.com> wrote:
> Hi,
> You're perfectly right... This error means that some objects are still
> owned by this user.
> In order to drop each object, you will first need to know what kind of
> objects are owned by the user you would like to delete. Then, you'll
> be able to run the correct drop commands in the query analyser...
> As an example, here are some usual drop commands :
> DROP TABLE [schema].[Table name]
> DROP VIEW [schema].[View name]
> DROP PROCEDURE [schema].[Procedure name]
> ...
> Whenever all the objects owned will be dropped, you'll be able to use
> the sp_dropuser procedure.
> Hope this helps,
> Cédric Del Nibbio
> MCTS SQL Server 2005
> MCSD .NET
> MCT
> http://cedric-delnibbio-sql.blogspot.com
>sql

Can't Drop Column or Shrink tran log

I am having problem getting the transaction log of a db
that is being replicated to shrink even after performing
a backup. There is about 500 MB of data in the database
and the trans log is almost 4GB. Dbcc checkdb returned no
error but dbcc opentran returned the following message:
Replicated Transaction Information:
Oldest distributed LSN : (0:0:0)
Oldest non-distributed LSN : (305:22434:1)
DBCC execution completed. If DBCC printed error messages,
contact your system administrator.
Also on this particular db, I can't add/drop column using
EM on the published db but can add column using
sp_repladdcolumn. When I tried to drop a column using
sp_repldropcolumn, I get the following message: "ALTER
TABLE DROP COLUMN failed because 'FieldName' is currently
replicated."
The column that I can't drop is not a pk or part of a pk
and there are no constraints. There is a relationship
between this table and another table on another column.
Thanks
Emma
Emma,
I remember this thread from a while back!
It seems you have some transactions (1 or more) in the log which have not
been read by a log reader. Run your log reader agent for all publications in
this database, then turn them off and make sure no-one else can modify the
data. Run sp_replcmds to see if this returns anything else. If it does then
consider running sp_repldone. This will mark the log as having been read
completely, and you'll then be able to back it up and shrink it.
First, have a look in BOL for the 2 sps above to familiarize yourself with
them. Also, make sure you have a backup before attempting this fix.
HTH,
Paul Ibison
|||Paul,
According to BOL, sp_replcmds and sp_repldone are for
transactional replication. I am running a merge
replication. Does this make any difference?
Thanks
Emma

>--Original Message--
>Emma,
>I remember this thread from a while back!
>It seems you have some transactions (1 or more) in the
log which have not
>been read by a log reader. Run your log reader agent for
all publications in
>this database, then turn them off and make sure no-one
else can modify the
>data. Run sp_replcmds to see if this returns anything
else. If it does then
>consider running sp_repldone. This will mark the log as
having been read
>completely, and you'll then be able to back it up and
shrink it.
>First, have a look in BOL for the 2 sps above to
familiarize yourself with
>them. Also, make sure you have a backup before
attempting this fix.
>HTH,
>Paul Ibison
>
>.
>
|||Emma,
Yes! I assumed it was transactional, as the output of dbcc opentran looks
like that of transactional. Have you perhaps ever set up transactional
previously then disabled it? If so, please try running sp_repldone then see
if dbcc opentran reports anything different - hopefully no transactions will
be reported. Only do this if you don't have any current transactional
publications based on this database. As a last resort (backup your databases
before trying this), you could detach the database, delete the transaction
log, then reattach the database and a new empty log should be created for
you (I have had cause to do this previously and it worked).
HTH,
Paul Ibison
|||Paul,
Thanks for all your help. I have tried everything and
nothing is working. sp_repldone tells me that the
database is not published. I could not detach the
database because it is being replicated. I even stopped
the SQL services and deleted the log file, but this
generated an error when I restarted the database so I had
to restore the file. I disabled publication on the
database and tried to delete a column, and it tells me
that I can't delete because the table is being
replicated. Is my database corrupt? How can I get around
these problems? The two things I am trying to do is drop
a column from a published table and shrink my log file.
Any suggestions as to what I can do?
Thanks
Emma

>--Original Message--
>Emma,
>Yes! I assumed it was transactional, as the output of
dbcc opentran looks
>like that of transactional. Have you perhaps ever set up
transactional
>previously then disabled it? If so, please try running
sp_repldone then see
>if dbcc opentran reports anything different - hopefully
no transactions will
>be reported. Only do this if you don't have any current
transactional
>publications based on this database. As a last resort
(backup your databases
>before trying this), you could detach the database,
delete the transaction
>log, then reattach the database and a new empty log
should be created for
>you (I have had cause to do this previously and it
worked).
>HTH,
>Paul Ibison
>
>.
>
|||Emma,
try running
exec sp_dboption - to see the current settings
exec sp_dboption 'pubs','published',false
exec sp_dboption 'pubs','merge publish',false
This should allow you to detach the database and remove the log.
For the table, if it is still a problem, there is a stored procedure to do
this called sp_MSunmarkreplinfo which takes a tablename as a parameter.
Alternatively, setting replinfo to 0 in sysobjects for the particular table
should do it. Finally, running sp_removedbreplication can be used to remove
all traces of replication in the database, but obviously must only be done
if this database is not also configured as a publisher.
Regards,
Paul Ibison
|||Paul,
Thanks again for your help. I will try what you suggested
and hope for the best. The db is also configured as a
publisher and here is the result of sp_dboption.
ANSI null default
ANSI nulls
ANSI padding
ANSI warnings
arithabort
auto create statistics
auto update statistics
autoclose
autoshrink
concat null yields null
cursor close on commit
db chaining
dbo use only
default to local cursor
merge publish
numeric roundabort
offline
published
quoted identifier
read only
recursive triggers
select into/bulkcopy
single user
subscribed
torn page detection
trunc. log on chkpt.

>--Original Message--
>Emma,
>try running
>exec sp_dboption - to see the current settings
>exec sp_dboption 'pubs','published',false
>exec sp_dboption 'pubs','merge publish',false
>This should allow you to detach the database and remove
the log.
>For the table, if it is still a problem, there is a
stored procedure to do
>this called sp_MSunmarkreplinfo which takes a tablename
as a parameter.
>Alternatively, setting replinfo to 0 in sysobjects for
the particular table
>should do it. Finally, running sp_removedbreplication
can be used to remove
>all traces of replication in the database, but obviously
must only be done
>if this database is not also configured as a publisher.
>Regards,
>Paul Ibison
>
>.
>

Can't detach database

I have a database I want to copy to a second server. The
simplest way seems to be detach, copy DB & Log files,
attach.
However, I can't detach the database. When I attempt to
detach it, it says there is 1 process connected. If I
look in the management tool, there are no processes
connected.
This is a dedicated server. I shut it down, disconnected
it from the network, then restarted. The only connection
shown is the management console I am using for the detach.
But it still shows 1 connection to the database I want to
detach.
Any help is greatly appreciated.Are you by any chance the 1 user in the database?
Try directly from QA without even starting Enterprise Manager executing the
following:
USE MASTER
Go
SP_DETACH_DB YourDB
HTH,
Des
On 24/11/2004 15:27, in article 995b01c4d231$b9ccbe50$a301280a@.phx.gbl, "DB"
<anonymous@.discussions.microsoft.com> wrote:

> I have a database I want to copy to a second server. The
> simplest way seems to be detach, copy DB & Log files,
> attach.
> However, I can't detach the database. When I attempt to
> detach it, it says there is 1 process connected. If I
> look in the management tool, there are no processes
> connected.
> This is a dedicated server. I shut it down, disconnected
> it from the network, then restarted. The only connection
> shown is the management console I am using for the detach.
> But it still shows 1 connection to the database I want to
> detach.
> Any help is greatly appreciated.|||I've the same issue once that what i do.
First be sure that you don't have replication enabled on the database (as a
publisher or published DB)
2nd.
On EM try to dettach the DB, immediatly go to Query analyzer and run
sp_who2, look for bloking sessions,the one that is blocking should be the on
e
that is avoiding the DB to be dettahced.
This should be enough to solve the issue.
Regards.
Frivas
"DB" wrote:

> I have a database I want to copy to a second server. The
> simplest way seems to be detach, copy DB & Log files,
> attach.
> However, I can't detach the database. When I attempt to
> detach it, it says there is 1 process connected. If I
> look in the management tool, there are no processes
> connected.
> This is a dedicated server. I shut it down, disconnected
> it from the network, then restarted. The only connection
> shown is the management console I am using for the detach.
> But it still shows 1 connection to the database I want to
> detach.
> Any help is greatly appreciated.
>|||Make sure your Object Browser is closed, if you have it open.
"DB" <anonymous@.discussions.microsoft.com> wrote in message
news:995b01c4d231$b9ccbe50$a301280a@.phx.gbl...
> I have a database I want to copy to a second server. The
> simplest way seems to be detach, copy DB & Log files,
> attach.
> However, I can't detach the database. When I attempt to
> detach it, it says there is 1 process connected. If I
> look in the management tool, there are no processes
> connected.
> This is a dedicated server. I shut it down, disconnected
> it from the network, then restarted. The only connection
> shown is the management console I am using for the detach.
> But it still shows 1 connection to the database I want to
> detach.
> Any help is greatly appreciated.

Can't detach database

I have a database I want to copy to a second server. The
simplest way seems to be detach, copy DB & Log files,
attach.
However, I can't detach the database. When I attempt to
detach it, it says there is 1 process connected. If I
look in the management tool, there are no processes
connected.
This is a dedicated server. I shut it down, disconnected
it from the network, then restarted. The only connection
shown is the management console I am using for the detach.
But it still shows 1 connection to the database I want to
detach.
Any help is greatly appreciated.
Are you by any chance the 1 user in the database?
Try directly from QA without even starting Enterprise Manager executing the
following:
USE MASTER
Go
SP_DETACH_DB YourDB
HTH,
Des
On 24/11/2004 15:27, in article 995b01c4d231$b9ccbe50$a301280a@.phx.gbl, "DB"
<anonymous@.discussions.microsoft.com> wrote:

> I have a database I want to copy to a second server. The
> simplest way seems to be detach, copy DB & Log files,
> attach.
> However, I can't detach the database. When I attempt to
> detach it, it says there is 1 process connected. If I
> look in the management tool, there are no processes
> connected.
> This is a dedicated server. I shut it down, disconnected
> it from the network, then restarted. The only connection
> shown is the management console I am using for the detach.
> But it still shows 1 connection to the database I want to
> detach.
> Any help is greatly appreciated.
|||I've the same issue once that what i do.
First be sure that you don't have replication enabled on the database (as a
publisher or published DB)
2nd.
On EM try to dettach the DB, immediatly go to Query analyzer and run
sp_who2, look for bloking sessions,the one that is blocking should be the one
that is avoiding the DB to be dettahced.
This should be enough to solve the issue.
Regards.
Frivas
"DB" wrote:

> I have a database I want to copy to a second server. The
> simplest way seems to be detach, copy DB & Log files,
> attach.
> However, I can't detach the database. When I attempt to
> detach it, it says there is 1 process connected. If I
> look in the management tool, there are no processes
> connected.
> This is a dedicated server. I shut it down, disconnected
> it from the network, then restarted. The only connection
> shown is the management console I am using for the detach.
> But it still shows 1 connection to the database I want to
> detach.
> Any help is greatly appreciated.
>
|||Make sure your Object Browser is closed, if you have it open.
"DB" <anonymous@.discussions.microsoft.com> wrote in message
news:995b01c4d231$b9ccbe50$a301280a@.phx.gbl...
> I have a database I want to copy to a second server. The
> simplest way seems to be detach, copy DB & Log files,
> attach.
> However, I can't detach the database. When I attempt to
> detach it, it says there is 1 process connected. If I
> look in the management tool, there are no processes
> connected.
> This is a dedicated server. I shut it down, disconnected
> it from the network, then restarted. The only connection
> shown is the management console I am using for the detach.
> But it still shows 1 connection to the database I want to
> detach.
> Any help is greatly appreciated.

Can't detach database

I have a database I want to copy to a second server. The
simplest way seems to be detach, copy DB & Log files,
attach.
However, I can't detach the database. When I attempt to
detach it, it says there is 1 process connected. If I
look in the management tool, there are no processes
connected.
This is a dedicated server. I shut it down, disconnected
it from the network, then restarted. The only connection
shown is the management console I am using for the detach.
But it still shows 1 connection to the database I want to
detach.
Any help is greatly appreciated.> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--B_3184155358_1551408
Content-type: text/plain;
charset="ISO-8859-1"
Content-transfer-encoding: 8bit
Are you by any chance the 1 user in the database?
Try directly from QA without even starting Enterprise Manager executing the
following:
USE MASTER
Go
SP_DETACH_DB ?YourDB¹
HTH,
Des
On 24/11/2004 15:27, in article 995b01c4d231$b9ccbe50$a301280a@.phx.gbl, "DB"
<anonymous@.discussions.microsoft.com> wrote:
> I have a database I want to copy to a second server. The
> simplest way seems to be detach, copy DB & Log files,
> attach.
> However, I can't detach the database. When I attempt to
> detach it, it says there is 1 process connected. If I
> look in the management tool, there are no processes
> connected.
> This is a dedicated server. I shut it down, disconnected
> it from the network, then restarted. The only connection
> shown is the management console I am using for the detach.
> But it still shows 1 connection to the database I want to
> detach.
> Any help is greatly appreciated.
--B_3184155358_1551408
Content-type: text/html;
charset="ISO-8859-1"
Content-transfer-encoding: quoted-printable
&

---

Re: Can't detach database
Are y=ou by any chance the 1 user in the database?
Try directly from QA without even starting Enterprise Manager executing the= following:
USE MASTER
Go
SP_DETACH_DB ‘YourDB’
HTH,
Des
On 24/11/2004 15:27, in article 995b01c4d231$b9ccbe50$a301280a@.phx.gbl, &qu=ot;DB" wrote:
> I have a database I want to copy to a second ser=ver. The
> simplest way seems to be detach, copy DB & Log files,
> attach.
>
> However, I can't detach the database. When I attempt to
> detach it, it says there is 1 process connected. If I
> look in the management tool, there are no processes
> connected.
>
> This is a dedicated server. I shut it down, disconnected
> it from the network, then restarted. The only connection
> shown is the management console I am using for the detach.
>
> But it still shows 1 connection to the database I want to
> detach.
>
> Any help is greatly appreciated.
--B_3184155358_1551408--|||I've the same issue once that what i do.
First be sure that you don't have replication enabled on the database (as a
publisher or published DB)
2nd.
On EM try to dettach the DB, immediatly go to Query analyzer and run
sp_who2, look for bloking sessions,the one that is blocking should be the one
that is avoiding the DB to be dettahced.
This should be enough to solve the issue.
Regards.
Frivas
"DB" wrote:
> I have a database I want to copy to a second server. The
> simplest way seems to be detach, copy DB & Log files,
> attach.
> However, I can't detach the database. When I attempt to
> detach it, it says there is 1 process connected. If I
> look in the management tool, there are no processes
> connected.
> This is a dedicated server. I shut it down, disconnected
> it from the network, then restarted. The only connection
> shown is the management console I am using for the detach.
> But it still shows 1 connection to the database I want to
> detach.
> Any help is greatly appreciated.
>|||Make sure your Object Browser is closed, if you have it open.
"DB" <anonymous@.discussions.microsoft.com> wrote in message
news:995b01c4d231$b9ccbe50$a301280a@.phx.gbl...
> I have a database I want to copy to a second server. The
> simplest way seems to be detach, copy DB & Log files,
> attach.
> However, I can't detach the database. When I attempt to
> detach it, it says there is 1 process connected. If I
> look in the management tool, there are no processes
> connected.
> This is a dedicated server. I shut it down, disconnected
> it from the network, then restarted. The only connection
> shown is the management console I am using for the detach.
> But it still shows 1 connection to the database I want to
> detach.
> Any help is greatly appreciated.

Cant Delete Row

I ran into a scenerio this morning

I made a table with no relations or primary id

It is an error log table basically

I went to delete a row and I got an error of

Cant delete row because it does not make them unigue or it alters multiple rows(3)

I didnt want this by no means, what did i not sdet right and how do you delete the rows without deleting the table and starting out new again?

Davids Learning

hi,

you'll often see this kind of problems on a table without a primary key... try defining one..

regards

|||

It wouldnt let me do that, so I deleted the table and started again(no big loss), but I did make a primary this time!

Thanks

Davids Learning

can't delete log files

Hi every one,
I'm trying to delete one of the two log files from a database but I get the
message "error 5042: the file databse_log cannot be removed because it is
not empty".
I have tried with the commands "backup log databasename with truncate_only"
and "dbcc shrinkfile (filename,emptyfile)" but no luck.
Can anyone tell me how to do it please.
Thanks to all,
Ivan MckenzieUse DBCC LOGINFO to verify that no virtual log files is in use in the ldf file. Google and you will
find articles etc. on how to use the DBCC LOGINFO command.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ivan Mckenzie" <imck@.inerza.com> wrote in message news:uUT%230SGIGHA.2680@.TK2MSFTNGP09.phx.gbl...
> Hi every one,
> I'm trying to delete one of the two log files from a database but I get the message "error 5042:
> the file databse_log cannot be removed because it is not empty".
> I have tried with the commands "backup log databasename with truncate_only" and "dbcc shrinkfile
> (filename,emptyfile)" but no luck.
> Can anyone tell me how to do it please.
> Thanks to all,
> Ivan Mckenzie
>

can't delete log files

Hi every one,
I'm trying to delete one of the two log files from a database but I get the
message "error 5042: the file databse_log cannot be removed because it is
not empty".
I have tried with the commands "backup log databasename with truncate_only"
and "dbcc shrinkfile (filename,emptyfile)" but no luck.
Can anyone tell me how to do it please.
Thanks to all,
Ivan Mckenzie
Use DBCC LOGINFO to verify that no virtual log files is in use in the ldf file. Google and you will
find articles etc. on how to use the DBCC LOGINFO command.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ivan Mckenzie" <imck@.inerza.com> wrote in message news:uUT%230SGIGHA.2680@.TK2MSFTNGP09.phx.gbl...
> Hi every one,
> I'm trying to delete one of the two log files from a database but I get the message "error 5042:
> the file databse_log cannot be removed because it is not empty".
> I have tried with the commands "backup log databasename with truncate_only" and "dbcc shrinkfile
> (filename,emptyfile)" but no luck.
> Can anyone tell me how to do it please.
> Thanks to all,
> Ivan Mckenzie
>

can't delete log files

Hi every one,
I'm trying to delete one of the two log files from a database but I get the
message "error 5042: the file databse_log cannot be removed because it is
not empty".
I have tried with the commands "backup log databasename with truncate_only"
and "dbcc shrinkfile (filename,emptyfile)" but no luck.
Can anyone tell me how to do it please.
Thanks to all,
Ivan MckenzieUse DBCC LOGINFO to verify that no virtual log files is in use in the ldf fi
le. Google and you will
find articles etc. on how to use the DBCC LOGINFO command.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ivan Mckenzie" <imck@.inerza.com> wrote in message news:uUT%230SGIGHA.2680@.TK2MSFTNGP09.phx.
gbl...
> Hi every one,
> I'm trying to delete one of the two log files from a database but I get th
e message "error 5042:
> the file databse_log cannot be removed because it is not empty".
> I have tried with the commands "backup log databasename with truncate_only
" and "dbcc shrinkfile
> (filename,emptyfile)" but no luck.
> Can anyone tell me how to do it please.
> Thanks to all,
> Ivan Mckenzie
>

Cant create new database -> no disk space (os error 112)

Hello everybody

Had some problems yesterday with a full transaction log. Was able to solve it by following microsofts knowledge base article n 272318.

However, today I'm trying to create a new DB using the enterprise manager and get this error:

d:\databases\HERCULES_1_Data.MDF: Operating system error 112(Es steht nicht genug Speicherplatz auf dem Datentrger zur Verfgung.) encountered.

The free disk space is > 60GB. That's by far enough... I only need 1-2 GB.

Any ideas what's wrong here?

Thanks anyone in advance for some guideance.

RenaudAre you sure both the log and the data files were being created on D? How much space is left on your C drive?|||Yes, both files on D:\ but not created at all of course, because of the insufficient disk space error message.

However, on C:\ there's 1.6 GB left. But IMO this shouldn't matter and not be related to the error message, right?|||How are you trying to create this database? By a script, or by Enterprise Manager?|||I'm using the enterprise manager|||How big is your model database? It should be about 1 or 2 MB in size.|||According to the database properties, general tab, the model database is 1.25MB in size with 0.27MB of free space.|||huh... exec xp_fixeddrives tells me:

On C, 1395MB free space
On D, 1MB free space

How can I fix it?|||... and EXEC xp_cmdshell 'dir d:\' gives me back:

1.298.432 Bytes free

Opening a command line (DOS box) and entering "dir d:\" gives me back:

64.280.199.168 Bytes free

?!?!?|||FOUND IT!! There were disk quotas activated on our SBS 2003 Server. Didn't realize that before. Seems to be a default setting when creating new user accounts on Windows. Our SQL Server runs under its own windows account. Wasn't aware of this, now I know better!

Thanks a lot for your help.

Renaud|||Thank you for reporting back the fix to a problem the rest of us may very well encounter.

Cant create database with > 4 GB log

Hi,

I got a backup file from my friend which needs 11 GB to hold the
transaction log. I tried to restore this database but an error
message:

"MODIFY FILE encountered operating system error 112(error not found)
while attempting to expand the physical file."

appeared. The free space is more than enough. I then tried another way
to create a database with a 11 gb log file but it fails with the same
error message whenever I tried to create any database with a file
larger than 4 GB. I'm using SQLServer 2000 pro. running on WinXP. Is
this the cause of this limitation?

p.s. I'm very new to the SQLServer.

Pls Help,
Will.pongthai@.msn.com (Pongthai) wrote in message news:<4bf99b6f.0405042008.9cc4e14@.posting.google.com>...
> Hi,
> I got a backup file from my friend which needs 11 GB to hold the
> transaction log. I tried to restore this database but an error
> message:
> "MODIFY FILE encountered operating system error 112(error not found)
> while attempting to expand the physical file."
> appeared. The free space is more than enough. I then tried another way
> to create a database with a 11 gb log file but it fails with the same
> error message whenever I tried to create any database with a file
> larger than 4 GB. I'm using SQLServer 2000 pro. running on WinXP. Is
> this the cause of this limitation?
> p.s. I'm very new to the SQLServer.
>
> Pls Help,
> Will.

I believe that 4GB is the maximum file size on a FAT32 filesystem, so
I would guess your hard drive is formatted with FAT32, not NTFS. You
should be able to convert it, as described here (make sure you back up
your data first):

http://support.microsoft.com/defaul...kb;en-us;307881

NTFS is the recommended filesystem for both Windows XP and SQL Server.

Simon|||Dear Will,

Umm yeh interesting, I am not sure but if the problem is "4GB", it may
be due to 4GB Memory constraint... However, the error number you
report belongs to operating system not SQL Server and it means disk is
full, no space for any more 0101010 on the disk!
:-)

Exact description of Error
"112 there is not enough space on the disk. ERROR_DISK_FULL"
http://msdn.microsoft.com/library/d...des__0-499_.asp

Please describe things a lil more

Thanks!
Me,
Saghir Taj
MCDBA

pongthai@.msn.com (Pongthai) wrote in message news:<4bf99b6f.0405042008.9cc4e14@.posting.google.com>...
> Hi,
> I got a backup file from my friend which needs 11 GB to hold the
> transaction log. I tried to restore this database but an error
> message:
> "MODIFY FILE encountered operating system error 112(error not found)
> while attempting to expand the physical file."
> appeared. The free space is more than enough. I then tried another way
> to create a database with a 11 gb log file but it fails with the same
> error message whenever I tried to create any database with a file
> larger than 4 GB. I'm using SQLServer 2000 pro. running on WinXP. Is
> this the cause of this limitation?
> p.s. I'm very new to the SQLServer.
>
> Pls Help,
> Will.|||Thanks for both answers. I'll have one of my hdd partition changed to
NTFS and try again.

Thanks,
Will.|||Simon may be right this may be one of cause!.. i would like to know
the exact cause of problem.. if you get some fix or exact descripton
of problem please let me know!

Me,
Saghir Taj
MCDBA

sql@.hayes.ch (Simon Hayes) wrote in message news:<60cd0137.0405050216.555cf13c@.posting.google.com>...
> pongthai@.msn.com (Pongthai) wrote in message news:<4bf99b6f.0405042008.9cc4e14@.posting.google.com>...
> > Hi,
> > I got a backup file from my friend which needs 11 GB to hold the
> > transaction log. I tried to restore this database but an error
> > message:
> > "MODIFY FILE encountered operating system error 112(error not found)
> > while attempting to expand the physical file."
> > appeared. The free space is more than enough. I then tried another way
> > to create a database with a 11 gb log file but it fails with the same
> > error message whenever I tried to create any database with a file
> > larger than 4 GB. I'm using SQLServer 2000 pro. running on WinXP. Is
> > this the cause of this limitation?
> > p.s. I'm very new to the SQLServer.
> > Pls Help,
> > Will.
> I believe that 4GB is the maximum file size on a FAT32 filesystem, so
> I would guess your hard drive is formatted with FAT32, not NTFS. You
> should be able to convert it, as described here (make sure you back up
> your data first):
> http://support.microsoft.com/defaul...kb;en-us;307881
> NTFS is the recommended filesystem for both Windows XP and SQL Server.
> Simon|||hi

has the problem solved

i am also facing the same problem

sara

Cant create database with > 4 GB log

Hi,

I got a backup file from my friend which needs 11 GB to hold the
transaction log. I tried to restore this database but an error
message:

"MODIFY FILE encountered operating system error 112(error not found)
while attempting to expand the physical file."

appeared. The free space is more than enough. I then tried another way
to create a database with a 11 gb log file but it fails with the same
error message whenever I tried to create any database with a file
larger than 4 GB. I'm using SQLServer 2000 pro. running on WinXP. Is
this the cause of this limitation?

p.s. I'm very new to the SQLServer.

Pls Help,
Will.pongthai@.msn.com (Pongthai) wrote in message news:<4bf99b6f.0405042008.9cc4e14@.posting.google.com>...
> Hi,
> I got a backup file from my friend which needs 11 GB to hold the
> transaction log. I tried to restore this database but an error
> message:
> "MODIFY FILE encountered operating system error 112(error not found)
> while attempting to expand the physical file."
> appeared. The free space is more than enough. I then tried another way
> to create a database with a 11 gb log file but it fails with the same
> error message whenever I tried to create any database with a file
> larger than 4 GB. I'm using SQLServer 2000 pro. running on WinXP. Is
> this the cause of this limitation?
> p.s. I'm very new to the SQLServer.
>
> Pls Help,
> Will.

I believe that 4GB is the maximum file size on a FAT32 filesystem, so
I would guess your hard drive is formatted with FAT32, not NTFS. You
should be able to convert it, as described here (make sure you back up
your data first):

http://support.microsoft.com/defaul...kb;en-us;307881

NTFS is the recommended filesystem for both Windows XP and SQL Server.

Simon|||Dear Will,

Umm yeh interesting, I am not sure but if the problem is "4GB", it may
be due to 4GB Memory constraint... However, the error number you
report belongs to operating system not SQL Server and it means disk is
full, no space for any more 0101010 on the disk!
:-)

Exact description of Error
"112 there is not enough space on the disk. ERROR_DISK_FULL"
http://msdn.microsoft.com/library/d...des__0-499_.asp

Please describe things a lil more

Thanks!
Me,
Saghir Taj
MCDBA

pongthai@.msn.com (Pongthai) wrote in message news:<4bf99b6f.0405042008.9cc4e14@.posting.google.com>...
> Hi,
> I got a backup file from my friend which needs 11 GB to hold the
> transaction log. I tried to restore this database but an error
> message:
> "MODIFY FILE encountered operating system error 112(error not found)
> while attempting to expand the physical file."
> appeared. The free space is more than enough. I then tried another way
> to create a database with a 11 gb log file but it fails with the same
> error message whenever I tried to create any database with a file
> larger than 4 GB. I'm using SQLServer 2000 pro. running on WinXP. Is
> this the cause of this limitation?
> p.s. I'm very new to the SQLServer.
>
> Pls Help,
> Will.|||Thanks for both answers. I'll have one of my hdd partition changed to
NTFS and try again.

Thanks,
Will.|||Simon may be right this may be one of cause!.. i would like to know
the exact cause of problem.. if you get some fix or exact descripton
of problem please let me know!

Me,
Saghir Taj
MCDBA

sql@.hayes.ch (Simon Hayes) wrote in message news:<60cd0137.0405050216.555cf13c@.posting.google.com>...
> pongthai@.msn.com (Pongthai) wrote in message news:<4bf99b6f.0405042008.9cc4e14@.posting.google.com>...
> > Hi,
> > I got a backup file from my friend which needs 11 GB to hold the
> > transaction log. I tried to restore this database but an error
> > message:
> > "MODIFY FILE encountered operating system error 112(error not found)
> > while attempting to expand the physical file."
> > appeared. The free space is more than enough. I then tried another way
> > to create a database with a 11 gb log file but it fails with the same
> > error message whenever I tried to create any database with a file
> > larger than 4 GB. I'm using SQLServer 2000 pro. running on WinXP. Is
> > this the cause of this limitation?
> > p.s. I'm very new to the SQLServer.
> > Pls Help,
> > Will.
> I believe that 4GB is the maximum file size on a FAT32 filesystem, so
> I would guess your hard drive is formatted with FAT32, not NTFS. You
> should be able to convert it, as described here (make sure you back up
> your data first):
> http://support.microsoft.com/defaul...kb;en-us;307881
> NTFS is the recommended filesystem for both Windows XP and SQL Server.
> Simon

Can't connect to SQL Server 2005 Reporting Services

Hi all, for some reason I can't connect to SQL Server 2005 reporting services. When I try to log in I get "the request failed with HTTP status 404:Not Found".

When I installed SQL Server, port 80 was not available as I am also running Apache, so SQL Server Report Server runs at http://localhost:81/ReportServer/ .. this work fine, I have build a report, deployed it successfully and can view it.

In SSMS I see two 2 databases, ReportServer and ReportServerTempDB.

Everything looks OK in the Report Server Configuration Manager, however in the Surface Area Configuration when I click on "
Windows Integrated Security" under the Reporting Services node it also comes back as "the request failed with HTTP status 404:Not Found"

Does anyone have any ideas how I can fix this, does it look like it is looking for Reporting Services on the wrong port? 80 instead of 81 ?

Thanks for any advice

Hello, I have had a similar problem and posted a thread on it at: http://tinyurl.com/zke4g

I've been running IIS 5.1 on port 200 just for security as hackers go straight for 80 if they are trying anything. While my problem is similar to yours, I have seen nothing that says the port is the problem especially given it persists when I switch IIS to port 80. A common move with Apach is to go into the config file and set apache to :8080, I've done that though it's been years and the details of how to are fuzzy.

Good luck. - Greg

Can't Connect to database instance

Hi,

Yesterday I was able to connect to the server, and now it's telling me I can't log in via the SQL Server manager.

the database has a red stop signal on it, and I'm not sure what caused this.

I did install Windows XP IIS (Internet Information Services) yesterday. Could this have caused this?

How do I get the database started again?

The error I'm getting during login attempt is this...

===================================

Cannot connect to <MYSERVER>.

===================================

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

Error Number: -1
Severity: 20
State: 0

Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Can you use sql server configuration manager to see if you sql server is running?|||

The following post in this forum may be of some help:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1334187&SiteID=1