Can't get mirroring working for all DBs?

I'm getting the following errors when trying to set up mirroring for a DB.
[PRINCIPAL]
Date3/2/2007 2:52:06 PM
LogSQL Server (Current - 3/5/2007 8:44:00 AM)
Sourcespid99
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.
Date3/2/2007 2:52:06 PM
LogSQL Server (Current - 3/5/2007 8:44:00 AM)
Sourcespid99
Message
Error: 1413, Severity: 16, State: 1.
Date3/2/2007 2:52:06 PM
LogSQL Server (Current - 3/5/2007 8:44:00 AM)
Sourcespid37s
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.
Date3/2/2007 2:52:06 PM
LogSQL Server (Current - 3/5/2007 8:44:00 AM)
Sourcespid37s
Message
Error: 1479, Severity: 16, State: 1.
[MIRROR]
Date3/2/2007 2:52:49 PM
LogSQL Server (Current - 3/5/2007 8:46:00 AM)
Sourcespid35s
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.
Date3/2/2007 2:52:49 PM
LogSQL Server (Current - 3/5/2007 8:46:00 AM)
Sourcespid35s
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...
>
>
|||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:
[vbcol=seagreen]
> 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:
sql

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 causin
g
> the timeout.
> M.
>
> "slin" <slin@.discussions.microsoft.com> wrote in message
> news:E52523C6-0B5C-4507-B6FA-9439EFD1C02E@.microsoft.com...
>
>|||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 di
d
the whole restore/backup process and mirroring started right up.
"slin" wrote:
[vbcol=seagreen]
> 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:
>

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 exclusive access

While attempting to restore a db, I get the following error message:
"RESTORE DATABASE is terminating abnormally.
Exclusive access could not be obtained because the database is in use."
But looking at Current Activity in EM, I see nothing logged into the
database. The database I am restoring to is set to Single-User. Any
suggestions?
SQL 2000, sp4
Thanks,
SteveRunning the statement first
ALTER DATABASE <Nameofthedb> SET SINGLE_USER with rollback immediate
If you want to do that from Query Analyzer, make sure that you cursor is NOT
positioned on the DB node you want to restore.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Steve Deering" <Steve@.vin.com> schrieb im Newsbeitrag
news:1118060114.644682.280310@.g43g2000cwa.googlegroups.com...
> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>|||If it still complains, disconnect all your EM sessions.
"Steve Deering" <Steve@.vin.com> wrote in message
news:1118060114.644682.280310@.g43g2000cwa.googlegroups.com...
> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>|||Hi,
Try the below:-
1. From Query analyzer set the database to SINLE USER.
USE MASTER
GO
ALTER DATABASE <DBNAME> SET SINGLE_USER with rollback immediate
2. Restore the database
RESTORE DATABASE <DBNAME> FROM DISK='FILENAME WITH PATH' WITH STATS=10
Incase if the restore still fails then, close the query analyzer fully once
and try the RESTORE DATABASE again.
Thanks
Hari
SQL Server MVP
"Steve Deering" <Steve@.vin.com> wrote in message
news:1118060114.644682.280310@.g43g2000cwa.googlegroups.com...
> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>|||Make sure that the database is NOT selected in EM. I've had the exact same
problem and when I selected a different db in EM (master for instance) and
re-ran the restore from Query Analyzer it worked fine.
"Steve Deering" wrote:
> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>|||If you are married to using the SQLEM, then here is a trick I often use:
1. Right-click the database.
2. Detach the database. If there are users currently connected, then select
to disconnect them all without notifying them. When it is done, cancel so
you don't actually detach the database.
3. Now, right-click again and set Offline.
Now, you should be able to restore the database without any problems. Yes,
you can restore a database if it is marked offline.
Sometimes, however, you can not click fast enough to set it offline before
another user logs in. You can try this procedures a few time, but at some
point, you are just going to be stuck with script.
I usually use the same syntax as everyone else has shown you, but I like to
set the database offline instead of single-user.
Regardless, before SQL Server 2000, there was no other way to disconnect
users other than scripting out multiple KILL commands to get rid of all the
connections.
Sincerely,
Anthony Thomas
"Steve Deering" <Steve@.vin.com> wrote in message
news:1118060114.644682.280310@.g43g2000cwa.googlegroups.com...
While attempting to restore a db, I get the following error message:
"RESTORE DATABASE is terminating abnormally.
Exclusive access could not be obtained because the database is in use."
But looking at Current Activity in EM, I see nothing logged into the
database. The database I am restoring to is set to Single-User. Any
suggestions?
SQL 2000, sp4
Thanks,
Steve

Can't get exclusive access

While attempting to restore a db, I get the following error message:
"RESTORE DATABASE is terminating abnormally.
Exclusive access could not be obtained because the database is in use."
But looking at Current Activity in EM, I see nothing logged into the
database. The database I am restoring to is set to Single-User. Any
suggestions?
SQL 2000, sp4
Thanks,
Steve
Running the statement first
ALTER DATABASE <Nameofthedb> SET SINGLE_USER with rollback immediate
If you want to do that from Query Analyzer, make sure that you cursor is NOT
positioned on the DB node you want to restore.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Steve Deering" <Steve@.vin.com> schrieb im Newsbeitrag
news:1118060114.644682.280310@.g43g2000cwa.googlegr oups.com...
> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>
|||If it still complains, disconnect all your EM sessions.
"Steve Deering" <Steve@.vin.com> wrote in message
news:1118060114.644682.280310@.g43g2000cwa.googlegr oups.com...
> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>
|||Hi,
Try the below:-
1. From Query analyzer set the database to SINLE USER.
USE MASTER
GO
ALTER DATABASE <DBNAME> SET SINGLE_USER with rollback immediate
2. Restore the database
RESTORE DATABASE <DBNAME> FROM DISK='FILENAME WITH PATH' WITH STATS=10
Incase if the restore still fails then, close the query analyzer fully once
and try the RESTORE DATABASE again.
Thanks
Hari
SQL Server MVP
"Steve Deering" <Steve@.vin.com> wrote in message
news:1118060114.644682.280310@.g43g2000cwa.googlegr oups.com...
> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>
|||Make sure that the database is NOT selected in EM. I've had the exact same
problem and when I selected a different db in EM (master for instance) and
re-ran the restore from Query Analyzer it worked fine.
"Steve Deering" wrote:

> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>
|||If you are married to using the SQLEM, then here is a trick I often use:
1. Right-click the database.
2. Detach the database. If there are users currently connected, then select
to disconnect them all without notifying them. When it is done, cancel so
you don't actually detach the database.
3. Now, right-click again and set Offline.
Now, you should be able to restore the database without any problems. Yes,
you can restore a database if it is marked offline.
Sometimes, however, you can not click fast enough to set it offline before
another user logs in. You can try this procedures a few time, but at some
point, you are just going to be stuck with script.
I usually use the same syntax as everyone else has shown you, but I like to
set the database offline instead of single-user.
Regardless, before SQL Server 2000, there was no other way to disconnect
users other than scripting out multiple KILL commands to get rid of all the
connections.
Sincerely,
Anthony Thomas

"Steve Deering" <Steve@.vin.com> wrote in message
news:1118060114.644682.280310@.g43g2000cwa.googlegr oups.com...
While attempting to restore a db, I get the following error message:
"RESTORE DATABASE is terminating abnormally.
Exclusive access could not be obtained because the database is in use."
But looking at Current Activity in EM, I see nothing logged into the
database. The database I am restoring to is set to Single-User. Any
suggestions?
SQL 2000, sp4
Thanks,
Steve

Can't get exclusive access

While attempting to restore a db, I get the following error message:
"RESTORE DATABASE is terminating abnormally.
Exclusive access could not be obtained because the database is in use."
But looking at Current Activity in EM, I see nothing logged into the
database. The database I am restoring to is set to Single-User. Any
suggestions?
SQL 2000, sp4
Thanks,
SteveRunning the statement first
ALTER DATABASE <Nameofthedb> SET SINGLE_USER with rollback immediate
If you want to do that from Query Analyzer, make sure that you cursor is NOT
positioned on the DB node you want to restore.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Steve Deering" <Steve@.vin.com> schrieb im Newsbeitrag
news:1118060114.644682.280310@.g43g2000cwa.googlegroups.com...
> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>|||If it still complains, disconnect all your EM sessions.
"Steve Deering" <Steve@.vin.com> wrote in message
news:1118060114.644682.280310@.g43g2000cwa.googlegroups.com...
> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>|||Hi,
Try the below:-
1. From Query analyzer set the database to SINLE USER.
USE MASTER
GO
ALTER DATABASE <DBNAME> SET SINGLE_USER with rollback immediate
2. Restore the database
RESTORE DATABASE <DBNAME> FROM DISK='FILENAME WITH PATH' WITH STATS=10
Incase if the restore still fails then, close the query analyzer fully once
and try the RESTORE DATABASE again.
Thanks
Hari
SQL Server MVP
"Steve Deering" <Steve@.vin.com> wrote in message
news:1118060114.644682.280310@.g43g2000cwa.googlegroups.com...
> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>|||Make sure that the database is NOT selected in EM. I've had the exact same
problem and when I selected a different db in EM (master for instance) and
re-ran the restore from Query Analyzer it worked fine.
"Steve Deering" wrote:

> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>|||If you are married to using the SQLEM, then here is a trick I often use:
1. Right-click the database.
2. Detach the database. If there are users currently connected, then select
to disconnect them all without notifying them. When it is done, cancel so
you don't actually detach the database.
3. Now, right-click again and set Offline.
Now, you should be able to restore the database without any problems. Yes,
you can restore a database if it is marked offline.
Sometimes, however, you can not click fast enough to set it offline before
another user logs in. You can try this procedures a few time, but at some
point, you are just going to be stuck with script.
I usually use the same syntax as everyone else has shown you, but I like to
set the database offline instead of single-user.
Regardless, before SQL Server 2000, there was no other way to disconnect
users other than scripting out multiple KILL commands to get rid of all the
connections.
Sincerely,
Anthony Thomas
"Steve Deering" <Steve@.vin.com> wrote in message
news:1118060114.644682.280310@.g43g2000cwa.googlegroups.com...
While attempting to restore a db, I get the following error message:
"RESTORE DATABASE is terminating abnormally.
Exclusive access could not be obtained because the database is in use."
But looking at Current Activity in EM, I see nothing logged into the
database. The database I am restoring to is set to Single-User. Any
suggestions?
SQL 2000, sp4
Thanks,
Steve

Cant find SQL Server

I have the following in my web.config

<appSettings>
<add key="strConn" value="server=10.100.1.2;uid=sa;pwd=;database=MyDB/>
</appSettings
and I am getting the following error message --

"SQL Server cannot be found or access denied"

if I replace the server IP address with server name, it works fine.

Am I missing something here? Help!

Thanks

Bugme

See the linkhttp://blogs.msdn.com/sql_protocols/archive/2005/10/29/486861.aspx has some information. Hope that helps you!

My guess is name resolution faild!

Can't find microsoft.sqlserver.execpackagetaskwrap.dll in Sept CTP

I'm trying to find the following reference for a VS2005 C# project but can't see to locate it on two of my machines which uses Sept CTP install (Ent & Dev) both with SQL2K already installed:

Namespace: Microsoft.SqlServer.Dts.Tasks.ExecutePackageTask
Assembly: Microsoft.SqlServer.ExecPackageTaskWrap (in microsoft.sqlserver.execpackagetaskwrap.dll)

The only thing that I can find is ..\Program Files\Microsoft SQL Server\90\DTS\Binn\ExecPackageTask.dll

Is that the same thing or am I missing something? Thanks.

It's in the GAC.

|||Thanks but I still can't reference it in my C# project. Is it referenceable or use within another namespace?|||

Try this:

Right click References --> Add Reference in your C# project
In Add Reference dialog select Browse page.
In File Name type:

%windir%\assembly\GAC_MSIL\Microsoft.SqlServer.ExecPackageTaskWrap\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.ExecPackageTaskWrap.dll

P.S. You don't need it if you access properties using TaskHost.Properties[]

sql

can't find database when trying to restore

Hi I am trying to copy a complete database and did the following.
backup database, saved file at location
C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\database.bak
on machine 1-source machine.
I then copied this to
C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\
on machine two-destination machine.
I was thinking I could then use the restore from EM connected to the
destination machine but when I select restore the database name does not show
up as one of the databases that can be selected.
Thanks.
Paul G
Software engineer.
No it wont show the database in Restore database window. It will shoe only
the current database. Use have to use "From Device" option and select the bak
file from there and type the name of database.
Thanks
Ravi
"Paul" wrote:

> Hi I am trying to copy a complete database and did the following.
> backup database, saved file at location
> C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\database.bak
> on machine 1-source machine.
> I then copied this to
> C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\
> on machine two-destination machine.
> I was thinking I could then use the restore from EM connected to the
> destination machine but when I select restore the database name does not show
> up as one of the databases that can be selected.
> Thanks.
> --
> Paul G
> Software engineer.
|||ok thanks it worked!.
Paul G
Software engineer.
"Ravi" wrote:
[vbcol=seagreen]
> No it wont show the database in Restore database window. It will shoe only
> the current database. Use have to use "From Device" option and select the bak
> file from there and type the name of database.
>
> --
> Thanks
> Ravi
>
> "Paul" wrote:

can't find database when trying to restore

Hi I am trying to copy a complete database and did the following.
backup database, saved file at location
C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\database.bak
on machine 1-source machine.
I then copied this to
C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\
on machine two-destination machine.
I was thinking I could then use the restore from EM connected to the
destination machine but when I select restore the database name does not sho
w
up as one of the databases that can be selected.
Thanks.
--
Paul G
Software engineer.No it wont show the database in Restore database window. It will shoe only
the current database. Use have to use "From Device" option and select the ba
k
file from there and type the name of database.
Thanks
Ravi
"Paul" wrote:

> Hi I am trying to copy a complete database and did the following.
> backup database, saved file at location
> C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\database.bak
> on machine 1-source machine.
> I then copied this to
> C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\
> on machine two-destination machine.
> I was thinking I could then use the restore from EM connected to the
> destination machine but when I select restore the database name does not s
how
> up as one of the databases that can be selected.
> Thanks.
> --
> Paul G
> Software engineer.|||ok thanks it worked!.
--
Paul G
Software engineer.
"Ravi" wrote:
[vbcol=seagreen]
> No it wont show the database in Restore database window. It will shoe only
> the current database. Use have to use "From Device" option and select the
bak
> file from there and type the name of database.
>
> --
> Thanks
> Ravi
>
> "Paul" wrote:
>sql

can't find database when trying to restore

Hi I am trying to copy a complete database and did the following.
backup database, saved file at location
C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\database.bak
on machine 1-source machine.
I then copied this to
C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\
on machine two-destination machine.
I was thinking I could then use the restore from EM connected to the
destination machine but when I select restore the database name does not show
up as one of the databases that can be selected.
Thanks.
--
Paul G
Software engineer.No it wont show the database in Restore database window. It will shoe only
the current database. Use have to use "From Device" option and select the bak
file from there and type the name of database.
Thanks
Ravi
"Paul" wrote:
> Hi I am trying to copy a complete database and did the following.
> backup database, saved file at location
> C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\database.bak
> on machine 1-source machine.
> I then copied this to
> C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\
> on machine two-destination machine.
> I was thinking I could then use the restore from EM connected to the
> destination machine but when I select restore the database name does not show
> up as one of the databases that can be selected.
> Thanks.
> --
> Paul G
> Software engineer.|||ok thanks it worked!.
--
Paul G
Software engineer.
"Ravi" wrote:
> No it wont show the database in Restore database window. It will shoe only
> the current database. Use have to use "From Device" option and select the bak
> file from there and type the name of database.
>
> --
> Thanks
> Ravi
>
> "Paul" wrote:
> > Hi I am trying to copy a complete database and did the following.
> > backup database, saved file at location
> > C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\database.bak
> > on machine 1-source machine.
> > I then copied this to
> > C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\
> > on machine two-destination machine.
> > I was thinking I could then use the restore from EM connected to the
> > destination machine but when I select restore the database name does not show
> > up as one of the databases that can be selected.
> > Thanks.
> > --
> > Paul G
> > Software engineer.

Cant figure out error message in SQL

Can someone please look at my stored procedure? I am trying to create the following stored procedure, but get the following error
messages:

Msg 102, Level 15, State 1, Procedure InsertWork, Line 3
Incorrect syntax near '7'.
Msg 102, Level 15, State 1, Procedure InsertWork, Line 25
Incorrect syntax near'@.7am8am'.

USE [Work]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[InsertWork]
(
7am8am nvarchar(500),
8am9am nvarchar(500),
9am10am nvarchar(500),
10am11am nvarchar(500),
11am12noon nvarchar(500),
12Noon1pm nvarchar(500),
1pm2pm nvarchar(500),
2pm3pm nvarchar(500),
3pm4pm nvarchar(500),
4pm5pm nvarchar(500),
5pm6pm nvarchar(500),
6pm7pm nvarchar(500),
7pm8pm nvarchar(500),
8pm9pm nvarchar(500),
9pm10pm nvarchar(500),
10pm11pm nvarchar(500),
Notes nvarchar(500),
Date nvarchar(15)
)
AS BEGIN
INSERT INTO WorkDay
VALUES
@.7am8am,
@.8am9am,
@.9am10am,
@.10am11am,
@.11am12Noon,
@.12Noon1pm,
@.1pm2pm,
@.2pm3pm,
@.3pm4pm,
@.4pm5pm,
@.5pm6pm,
@.6pm7pm,
@.7pm8pm,
@.8pm9pm,
@.9pm10pm,
@.10pm11pm,
@.Notes,
@.Date
END

You cannot have variables/parameters names that starts with a number. Try prefixing them with an underscore (quick fix).

|||

johram:

You cannot have variables/parameters names that starts with a number.

Actually you can. The parameters have to start with @. for SQL Server to know its a parameter..

CREATE PROCEDURE [dbo].[InsertWork](@.7am8amnvarchar(500),@.8am9amnvarchar(500),@.9am10amnvarchar(500),@.10am11amnvarchar(500), @.11am12noonnvarchar(500),@.12Noon1pmnvarchar(500),@.1pm2pmnvarchar(500),@.2pm3pmnvarchar(500),@.3pm4pmnvarchar(500),@.4pm5pmnvarchar(500), @.5pm6pmnvarchar(500),@.6pm7pmnvarchar(500),@.7pm8pmnvarchar(500),@.8pm9pmnvarchar(500),@.9pm10pmnvarchar(500), @.10pm11pmnvarchar(500),@.Notesnvarchar(500),@.Datenvarchar(15))AS BEGIN INSERT INTO WorkDayVALUES (@.7am8am, @.8am9am,@.9am10am, @.10am11am, @.11am12Noon,@.12Noon1pm,@.1pm2pm,@.2pm3pm,@.3pm4pm,@.4pm5pm,@.5pm6pm,@.6pm7pm,@.7pm8pm, @.8pm9pm,@.9pm10pm,@.10pm11pm,@.Notes,@.Date )END

|||

ndinakar:

Actually you can. The parameters have to start with @. for SQL Server to know its a parameter..

Of course :-)

Can't extract key with rskeymgmt

I'm trying to move my RS from one machine to another. Following the MS
instructions found on
http://support.microsoft.com/?kbid=842425, it says to extract the
encryption key. When I try that, i get
C:>rskeymgmt.exe -e -f c:\rskey.txt -p thepassword
Are you sure you want to extract the key from the report server (Y/N)?
y
The local NT Service is disabled 0x80090005
What service would that be? I've seen similar posts with no
resolution. thanks in advance,
steveIhave the same problem
windows 2003 with SP1 and RS 2000 with SP2
any advice?
"sfp" wrote:
> I'm trying to move my RS from one machine to another. Following the MS
> instructions found on
> http://support.microsoft.com/?kbid=842425, it says to extract the
> encryption key. When I try that, i get
> C:>rskeymgmt.exe -e -f c:\rskey.txt -p thepassword
> Are you sure you want to extract the key from the report server (Y/N)?
> y
> The local NT Service is disabled 0x80090005
> What service would that be? I've seen similar posts with no
> resolution. thanks in advance,
> steve
>|||Unfortunately, no. I could not find a solution so I gave up. I
recreated manually. I'd be interested to hear if you find a solution
tho!
Cheers,
Steve
Josky wrote:
> Ihave the same problem
> windows 2003 with SP1 and RS 2000 with SP2
> any advice?
> "sfp" wrote:
> > I'm trying to move my RS from one machine to another. Following the MS
> > instructions found on
> > http://support.microsoft.com/?kbid=842425, it says to extract the
> > encryption key. When I try that, i get
> >
> > C:>rskeymgmt.exe -e -f c:\rskey.txt -p thepassword
> > Are you sure you want to extract the key from the report server (Y/N)?
> > y
> >
> > The local NT Service is disabled 0x80090005
> >
> > What service would that be? I've seen similar posts with no
> > resolution. thanks in advance,
> >
> > steve
> >
> >|||Switch the Account of the Rport Server Service to "NETWORK SERVICE" before
you backup the Key.sql

Cant enable database for full-text searching

When trying to create a new full-text catalogue for a database through enterprise manager the following error is generated:

The Microsoft Search service cannot be administered under the present user account

When attempting to enable a database for full-text searching by running the stored procedure "sp_fulltext_database" the following error message is recieved:

Server: Msg 7635, Level 16, State 1, Procedure sp_fulltext_database, Line 46
The Microsoft Search service cannot be administered under the present user account

The user account that the SQL service is running under has full administrative rights (including the privileges such as log on locally/as a batch/as a service etc - the SQL BUILTIN\Adminstrators login also exists) and the MSSQL and MS Search services have been stopped and started to ensure that the system account does have control of the MS Search service.

Although the text of the error message refers to user rights, line 46 of the stored procedure refers to the DBCC CALLFULLTEXT function and so it appears that the process is actually falling over when trying to drop catalogues.

The server was upgraded from SQL Server 6.5 to SQL Server 2000 and the Full-Text Search component was selected. However it was noticed that the folders Config, Projects and GatherLogs were not present under the following directory:

C:\Program files\Microsoft SQL Server\MSSQL\FTData\SQL Server\

(It was attempted to reinstall the Full-Text Search component from the SQL 2000 CD but as the component was already installed this wasnt possible)

The relevant config files, including the schema.txt, were then copied to the above location and it was ensured that the schema.txt file was the same in both the above location and the MSSQL\Binn folder (and on the SQL 2000 CD). But this has had no effect.

It has also been noticed that there is no registry key relating to:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\SQLFTSearch\Setup\Schema

However we have another server (which was a SQL 2000 install, as opposed to an upgrade) which also doesnt have this registry entry and that server isnt experiencing any problems with full-text search/indexing.

Can anyone suggest any other possible fixes before we resort to reinstalling SQL server?

Thanks,
ElaineHave you tried to run the stored procedure or sp_fulltext_database using query analyzer ?|||I'd be looking at the following closely ( assuming you may not have checked these out already ):

www.microsoft.com/technet

www.sqlmag.com

I'd be checking technet first as it sounds awfully like a upgrade "undocumented" type problem.

Apart from that, sounds like you have done everyting else right.

Try setting the SQL Server account to run under a domain account, but make sure you set the startup account to be the same in the Server Properties tab in EM as the account you use when you alter the startup account in Services. This is for the benefit of the Full Text service.

Post back if probs.

J.|||Thanks for your suggestions

...but we resorted to reinstalling SQL which has worked, so it appears that there might be problems with the full-text feature if you've upgraded to sql 2000 from 6.5 (as opposed to a straight 2000 install).

(we retained the databases by detaching them and copying the .mdf/.ldf files to another location. Then once the new install of SQL 2000 was complete we re-attached the databases - NB. the detach/attach method doesn't cover DTS packages. Also if specific users are created for a DB after reattaching you might need to delete them from the DB user section, then recreate them in the security logins section)

Can't drop constraint

Hello,
I am using SS7.
I have a table with a column "yn_LockOut" with a default set to 0. I tried
to delete the column and got the following:
'tblGuidelineResponseOwner' table
- Error modifying column properties for 'yn_LockOut'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL
Server]'DF_tblGuideLineResponse_yn_LockOut' is not a constraint.
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not drop constraint.
See previous errors.
When I ran exec sp_helpconstraint 'tblGuidelineResponseOwner', I got:
constraint_type constraint_name
DEFAULT on column yn_LockOut DF_tblGuideLineResponse_yn_LockOut
I ran:
alter table tblGuidelineResponseOwner DROP CONSTRAINT
DF_tblGuideLineResponse_yn_LockOut
and got the error message:
'DF_tblGuideLineResponse_yn_LockOut' is not a constraint.
Server: Msg 3727, Level 16, State 1, Line 5
Could not drop constraint. See previous errors.
Any help with this would be appreciated.
--
Thanks in advance,
StevenSteven,
Check sp_unbindefault in BOL.
-Mark
This positing is as is
>--Original Message--
>Hello,
>I am using SS7.
>I have a table with a column "yn_LockOut" with a default
set to 0. I tried
>to delete the column and got the following:
>'tblGuidelineResponseOwner' table
>- Error modifying column properties for 'yn_LockOut'.
>ODBC error: [Microsoft][ODBC SQL Server Driver][SQL
>Server]'DF_tblGuideLineResponse_yn_LockOut' is not a
constraint.
>[Microsoft][ODBC SQL Server Driver][SQL Server]Could not
drop constraint.
>See previous errors.
>
>When I ran exec
sp_helpconstraint 'tblGuidelineResponseOwner', I got:
>constraint_type
constraint_name
>DEFAULT on column yn_LockOut
DF_tblGuideLineResponse_yn_LockOut
>
>I ran:
>alter table tblGuidelineResponseOwner DROP CONSTRAINT
>DF_tblGuideLineResponse_yn_LockOut
>and got the error message:
>'DF_tblGuideLineResponse_yn_LockOut' is not a constraint.
>Server: Msg 3727, Level 16, State 1, Line 5
>Could not drop constraint. See previous errors.
>Any help with this would be appreciated.
>--
>Thanks in advance,
>Steven
>
>.
>sql

Can't deploy report on the reporting server

Please help -
I am trying to deploy report on the server - getting following:
===================================
A connection could not be made to the report server
http://169.35.137.96/ReportServer/. (Microsoft Report Designer)
===================================
The server committed a protocol violation. Section=ResponseStatusLine
(Microsoft.ReportingServices.Designer)
--
Program Location:
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
methodname)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String
Item)
at
Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
at
Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String
url)
at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()
--
Regadrs,
Andyhello,
Can you connect to RS and Report Manager without any problems in your web
browser using this addresses
http://169.35.137.96/ReportServer/
http://169.35.137.96/Reports/
'
And if so can you deploy any files and create folders in Report Manager?
Regards,
Radoslaw Lebkowski
U¿ytkownik "andys" <asichevoy@.gmail.com.(donotspam)> napisa³ w wiadomo¶ci
news:8A5B8E82-44F9-4FE8-90EB-00F38FB6DB5D@.microsoft.com...
> Please help -
> I am trying to deploy report on the server - getting following:
> ===================================> A connection could not be made to the report server
> http://169.35.137.96/ReportServer/. (Microsoft Report Designer)
> ===================================> The server committed a protocol violation. Section=ResponseStatusLine
> (Microsoft.ReportingServices.Designer)
> --
> Program Location:
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
> methodname)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String
> Item)
> at
> Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String
> item)
> at
> Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
> at
> Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String
> url)
> at
> Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()
>
>
> --
> Regadrs,
> Andy

Can't delete subscription

Hello,

I delete the publication, but the subscription still exists.

If I will delete the abonement I get following error 21776(Can't find Name xxx in the list of the TransPublications).

I tryed to craete the publication for the failed subscription again, but then I get the error, that a subscription for this publication still exists.

What can I do? How can I delete the subscription ?

Many thx for help!

Which SQL version are you using? Do you use scripts or UI to drop publication and subscription? Is subscription pull and located on the remote server? Could you please provide detailed repro step by step?

Thanks

Yunjing

|||

hello,

we use sql server 2000 and droped the replication via tsql

subscription is push and located on the remote server. I think I must delete all informations manuell in the server protocols, but how?

thx

Can't delete job

When attempt to delete a job, the following error is
encountered:
Cannot add, update, or delete a job (or its steps or
schedules) that originated from an MSX server.
How would you reslove this?
Thanks,
BenDo you have master-target server configuration setup? If not, did you
recently rename your SQL Server?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Ben" <bluebells88@.yahoo.com> wrote in message
news:379601c3fdd4$05d89540$a001280a@.phx.gbl...
When attempt to delete a job, the following error is
encountered:
Cannot add, update, or delete a job (or its steps or
schedules) that originated from an MSX server.
How would you reslove this?
Thanks,
Ben|||Sorry, what is 'master-target server configuration
setup'?
The machine joined a domain group after the job is
created.
Thanks,
Ben
>--Original Message--
>Do you have master-target server configuration setup? If
not, did you
>recently rename your SQL Server?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>"Ben" <bluebells88@.yahoo.com> wrote in message
>news:379601c3fdd4$05d89540$a001280a@.phx.gbl...
>When attempt to delete a job, the following error is
>encountered:
>Cannot add, update, or delete a job (or its steps or
>schedules) that originated from an MSX server.
>How would you reslove this?
>Thanks,
>Ben
>
>.
>|||You probably have incorrect machine name in msdb..sysjobs. The old machine
name is still in msdb..sysjobs. Since you changed the machine name, SQLAgent
now thinks that this job is owned by a master server. You can change
the machine names for all jobs with below SQL Statement. Warning: Hacking
system tables is not supported and should be done with care (below should be
rather safe, though).
DECLARE @.srv sysname
SET @.srv = CAST(SERVERPROPERTY('ServerName') AS sysname)
UPDATE sysjobs SET originating_server = @.srv
NOTE:
If this is a target server (you have jobs sent from a master server), you
have to exclude them, so you don't transfer those jobs into local jobs:
WHERE originating_server = 'oldservname'
If you want to do this the supported way, see below KB article
http://support.microsoft.com/default.aspx?scid=kb;en-us;281642
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Ben" <bluebells88@.yahoo.com> wrote in message
news:44ba01c3fe7b$b69c3970$a101280a@.phx.gbl...
> Sorry, what is 'master-target server configuration
> setup'?
> The machine joined a domain group after the job is
> created.
> Thanks,
> Ben
> >--Original Message--
> >Do you have master-target server configuration setup? If
> not, did you
> >recently rename your SQL Server?
> >--
> >HTH,
> >Vyas, MVP (SQL Server)
> >http://vyaskn.tripod.com/
> >Is .NET important for a database professional?
> >http://vyaskn.tripod.com/poll.htm
> >
> >
> >"Ben" <bluebells88@.yahoo.com> wrote in message
> >news:379601c3fdd4$05d89540$a001280a@.phx.gbl...
> >When attempt to delete a job, the following error is
> >encountered:
> >
> >Cannot add, update, or delete a job (or its steps or
> >schedules) that originated from an MSX server.
> >
> >How would you reslove this?
> >
> >Thanks,
> >Ben
> >
> >
> >.
> >|||Thanks all for the helps.
Ben
>--Original Message--
>You probably have incorrect machine name in
msdb..sysjobs. The old machine
>name is still in msdb..sysjobs. Since you changed the
machine name, SQLAgent
>now thinks that this job is owned by a master server.
You can change
>the machine names for all jobs with below SQL Statement.
Warning: Hacking
>system tables is not supported and should be done with
care (below should be
>rather safe, though).
>DECLARE @.srv sysname
>SET @.srv = CAST(SERVERPROPERTY('ServerName') AS sysname)
>UPDATE sysjobs SET originating_server = @.srv
>
>NOTE:
>If this is a target server (you have jobs sent from a
master server), you
>have to exclude them, so you don't transfer those jobs
into local jobs:
>WHERE originating_server = 'oldservname'
>
>If you want to do this the supported way, see below KB
article
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;281642
>
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Ben" <bluebells88@.yahoo.com> wrote in message
>news:44ba01c3fe7b$b69c3970$a101280a@.phx.gbl...
>> Sorry, what is 'master-target server configuration
>> setup'?
>> The machine joined a domain group after the job is
>> created.
>> Thanks,
>> Ben
>> >--Original Message--
>> >Do you have master-target server configuration setup?
If
>> not, did you
>> >recently rename your SQL Server?
>> >--
>> >HTH,
>> >Vyas, MVP (SQL Server)
>> >http://vyaskn.tripod.com/
>> >Is .NET important for a database professional?
>> >http://vyaskn.tripod.com/poll.htm
>> >
>> >
>> >"Ben" <bluebells88@.yahoo.com> wrote in message
>> >news:379601c3fdd4$05d89540$a001280a@.phx.gbl...
>> >When attempt to delete a job, the following error is
>> >encountered:
>> >
>> >Cannot add, update, or delete a job (or its steps or
>> >schedules) that originated from an MSX server.
>> >
>> >How would you reslove this?
>> >
>> >Thanks,
>> >Ben
>> >
>> >
>> >.
>> >
>
>.
>

Can't Delete Job

Hello:
I've got an old job I am trying to delete from my SQL Server 2005.
Everytime I try to delete this, i get the following error:
The DELETE statement conflicted with the REFERENCE constraint
"FK_subplan_job_id". The conflict occred in the database "msdb", table
"dbo.sysmainplan_subplans", column 'job_id'.
I know what an FK is, and why the job can't be deleted, but how do I
resolve this? How can I delete this job?Greg wrote:
> Hello:
> I've got an old job I am trying to delete from my SQL Server 2005.
> Everytime I try to delete this, i get the following error:
> The DELETE statement conflicted with the REFERENCE constraint
> "FK_subplan_job_id". The conflict occred in the database "msdb", table
> "dbo.sysmainplan_subplans", column 'job_id'.
> I know what an FK is, and why the job can't be deleted, but how do I
> resolve this? How can I delete this job?
>
Was the job created by a maintenance plan? Looks like it might have
been, judging from the FK reference. You'll probably have to go through
the maintenance plan to delete the job.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Guess I believe it was -- I was using some sort of Wizard for my first
few jobs until I got my feet wet w/adding jobs w/o using a Wizard....
I'll let you know what I find out.
-Greg
Tracy McKibben wrote:
> Greg wrote:
> > Hello:
> >
> > I've got an old job I am trying to delete from my SQL Server 2005.
> > Everytime I try to delete this, i get the following error:
> >
> > The DELETE statement conflicted with the REFERENCE constraint
> > "FK_subplan_job_id". The conflict occred in the database "msdb", table
> > "dbo.sysmainplan_subplans", column 'job_id'.
> >
> > I know what an FK is, and why the job can't be deleted, but how do I
> > resolve this? How can I delete this job?
> >
> Was the job created by a maintenance plan? Looks like it might have
> been, judging from the FK reference. You'll probably have to go through
> the maintenance plan to delete the job.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Greg wrote:
> Guess I believe it was -- I was using some sort of Wizard for my first
> few jobs until I got my feet wet w/adding jobs w/o using a Wizard....
> I'll let you know what I find out.
Good man!! Leave dem wizards alone...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||It was a stupid wizard thing -- geez...I think Microsoft should leave
the wizarding to Harry Potter...
Thanks for your quick and professional answer!
-Greg
Tracy McKibben wrote:
> Greg wrote:
> > Guess I believe it was -- I was using some sort of Wizard for my first
> > few jobs until I got my feet wet w/adding jobs w/o using a Wizard....
> >
> > I'll let you know what I find out.
> Good man!! Leave dem wizards alone...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com

Can't Delete Job

Hello:
I've got an old job I am trying to delete from my SQL Server 2005.
Everytime I try to delete this, i get the following error:
The DELETE statement conflicted with the REFERENCE constraint
"FK_subplan_job_id". The conflict occred in the database "msdb", table
"dbo.sysmainplan_subplans", column 'job_id'.
I know what an FK is, and why the job can't be deleted, but how do I
resolve this? How can I delete this job?Greg wrote:
> Hello:
> I've got an old job I am trying to delete from my SQL Server 2005.
> Everytime I try to delete this, i get the following error:
> The DELETE statement conflicted with the REFERENCE constraint
> "FK_subplan_job_id". The conflict occred in the database "msdb", table
> "dbo.sysmainplan_subplans", column 'job_id'.
> I know what an FK is, and why the job can't be deleted, but how do I
> resolve this? How can I delete this job?
>
Was the job created by a maintenance plan? Looks like it might have
been, judging from the FK reference. You'll probably have to go through
the maintenance plan to delete the job.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Guess I believe it was -- I was using some sort of Wizard for my first
few jobs until I got my feet wet w/adding jobs w/o using a Wizard....
I'll let you know what I find out.
-Greg
Tracy McKibben wrote:
> Greg wrote:
> Was the job created by a maintenance plan? Looks like it might have
> been, judging from the FK reference. You'll probably have to go through
> the maintenance plan to delete the job.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Greg wrote:
> Guess I believe it was -- I was using some sort of Wizard for my first
> few jobs until I got my feet wet w/adding jobs w/o using a Wizard....
> I'll let you know what I find out.
Good man!! Leave dem wizards alone...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||It was a stupid wizard thing -- geez...I think Microsoft should leave
the wizarding to Harry Potter...
Thanks for your quick and professional answer!
-Greg
Tracy McKibben wrote:
> Greg wrote:
> Good man!! Leave dem wizards alone...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com