Stopping And Starting Mirroring
Jul 25, 2007
My problem is primarily with SQL backup but the instant question is with mirroring in SQL 2005. I have a log file that is out of control and I need to do a backup with truncate_only, but this is command is evidently disallowed while mirroring is enabled. Is it possible to temporarily deactivate or remove mirroring in order to get the backup log under control? Is it possible to do that and then 'resume' mirroring?
A secondary issue is that I don't think mirroring is actually working at this point in time anyway. In the Mirroring section of the database properties the Status window says "No connection: cannot connect to the mirror server instance," so the question of stopping and restarting may be moot.
How does one reestablish mirroring if the connection is lost?
Lots of questions, I know... I'm reading up on it, but I'm obviously not the guy who set it up in the first place! Thanks in advance for any help...
CB
View 4 Replies
ADVERTISEMENT
Feb 1, 2007
When our rep distribution services time-out (several times a day) some dba's just restart the service while others restart the rep job which starts the service. Are there any differences between these two methods? Does restarting the service inherit any changes made to the job's attributes?
Thanks!
View 1 Replies
View Related
Feb 9, 1999
Does anyone see any negative consequences to stopping and starting SQL Server nightly?
View 2 Replies
View Related
Apr 24, 2008
hello everyone,
I wonder if you can help me with a problem I have trying to support a web based application that uses SQL 2005.
The problem is that the application developers tell me that it is neccessary to stop and restart the SQL service as part of the troubleshooting process when their application stops working. Unfortunately, the customer has our application database on a clustered SQL instance that is used by other applications so they cannot just stop and restart the SQL service because this will have a major impact on all the other instances...
Is there another way that would effectively do the same thing as stopping and restarting the SQL service? I have read that dettaching and re-attaching might do the same but application developers say onlt stopping/restarting services is sufficient to break the connection with the application.
Any advice would be really welcome as I am completely new to SQL and struggling with this!
Many thanks, Nick.
View 5 Replies
View Related
Mar 7, 2008
I'm hosting sqlserver 2005 developer edition locally on windows vista.
I'm getting messages for allot of stuff.
I can't restart, stop, or start my sql server instance.
I can't start the full-text search service.
I get this when I try to start the full-text search service.
===================================
Unable to start service MSFTESQL on server PAUL-PC.
===================================
Access Denied (ObjectExplorer)
------------------------------
Program Location:
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.CheckServiceActionReturnValueSuccess(UInt32 returnValue)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.Start()
And when I try to restart the instance...
===================================
Unable to stop service MSSQLSERVER on server PAUL-PC.
===================================
Access Denied (ObjectExplorer)
------------------------------
Program Location:
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.CheckServiceActionReturnValueSuccess(UInt32 returnValue)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.Stop(Boolean stopDependentServices)
View 4 Replies
View Related
Feb 1, 2007
Say we need to replicate between 2 databases using transactional replication
So we create a publication on the first server and initialse the publication agent so that it takes a snapshot and starts the log reader to capture the transactions being keyed into it.
Then say we create a pull subscription from the second database but lets say we assume we already have the data from thepublication database already in it so no need to app,ly a snapshot over it, when the pull subscription starts we assume that only transactions in the log reader that occured AFTER the pull subscription was started would be applied. Is this correct?
Then say we need to stop the pull subscription for a short period then start it again (let say so that we can take a back up of the subscriber database and restore the database somewhere else and replication set up between these 2 with no chance of data being althered before the restore had finished) can someone confirm when we start the pull subscription again all the transactions that occurred during the stopped period will be applied when it is started again OR will it be the case that only the transactions since the pull subscription was restarted will be applied
Cheers
Matt
View 1 Replies
View Related
Nov 10, 2005
Hello All...
I am new to this forum (and new to SQL for that matter), so I hope this isn't a stupid question. I tried searching for the answer but couldn't find it here.
I am trying to start & stop SQL server through the command line so I can start & stop it as a scheduled task. Are there any switches for sqlmangr.exe I can use? Maybe another way?
Thanks....Dave S. <majordis@weco-group.com>
View 2 Replies
View Related
Feb 26, 2015
I have a job that runs a dtsx package (containing an infinite loop). What I want to do is set up a schedule to start the job at 8am and stop it at 5pm. The scheduling GUI doesn't give this kind of option (caveat: that I can see).
View 3 Replies
View Related
Sep 11, 2007
Hi guys
I've been dealing with a few problems with SQL Server 2005.
We don't want to give our DBA's local administrator access to the servers so we had a problem with SSIS which I managed to resolve by adding their global group into the local DCOm group and modifying the security properties of MsDtsServer.
Another problem I've come across is when you log into Management Studio as an account that has local administrator access to the server you have the Green symbol next to the registered server, you can then right click and Stop, Restart services etc.
If I log into Management Studio with an account that has full SQL sysadmin rights but not local administrator rights to the server then the Green symbol doesn't appear and the Stop, restart options are all greyed out - all other functionality appears okay, they just seem to lose the ability to remotely stop and start services.
All of the above is with Windows Firewall turned off, if the user has local administrator rights but the SQL Server has the Windows Firewall switched on they are unable to remotely stop and restart services.
Port 1433 is open on the firewall and program execptions are there for sqlbrowse.exe
Anyone come across this particular problem before?
Any help would be appreciated.
Cheers
Hanley
View 2 Replies
View Related
Oct 21, 1999
Hello:
We have a new sales force automation application for sales rep to log their contacts, etc. It runs on mssql 6.5, sp 4.
They log in and leave their connections on without logging off or leave their coonections idle .
We set the user connections fiarly high but we are concerned that the max amount of user connections weill be consumed and the sql serve becomes locked.
My questions are:
1) Is there any parameter in the sql server configuration that will log off idle users have a certain time and dsiconnect them?
2) A backup of the database will be made each night. If there is no parameter, would it be a good idea to stop and start the sql server every night to release the idle connections?
3) If so, how to stop sql server from the commadn and start it with a command line command and do this in a batch file as a scheduled task?
4) Is there any other way to release these idle connections each night?
Any information you can supply will be appreciated. THanks.
David Spaisman
View 1 Replies
View Related
May 8, 2008
Hi,
I've Configured the Mirroring using the two machines, I've checked up everything,creation of end points successfully on both the machines, databases are in full recovery mode as well.
while Start Mirroring i'm facing following error :
TITLE: Database Properties
------------------------------
An error occurred while starting mirroring.
------------------------------
ADDITIONAL INFORMATION:
Alter failed for Database 'MIS'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The server network address "TCP://DBD-P3-01047.macmill.com:5023" can not be reached or does not exist. Check the network address name and reissue the command. (Microsoft SQL Server, Error: 1418)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=1418&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
and when i'm using the following command :
ALTER DATABASE [mis] SET PARTNER =N'TCP://DBD-P3-01063.macmill.com:5022'
to start mirroring the following error has come up :
The partner server instance name must be distinct from the server instance that manages the database.
The ALTER DATABASE SET PARTNER command failed.
How can i resolve this issue?Help is greatly appreciated!!!!
- Hitesh
View 8 Replies
View Related
Apr 23, 2007
[RS 2005]
Given the starting and stopping points (time values), how do I generate values between these points.
For example, if I have 08 (representing Hour) as a starting point and 12 as a stopping point.
From this I would like to generate a data sequence like 08, 09, 10, 11, and 12.
So how do I accomplish this? In SQL or in the RS?
The only thing I can think of is using a WHILE loop and a temporary table in SQL (not to keen on doing this).
//Håkan
View 7 Replies
View Related
May 18, 2007
Hello,
I had created a windows service using C#. I set its Startup Type as Automatic but it is not getting started automatically when my System Starts.
View 3 Replies
View Related
Mar 6, 2002
We have SQL 2000 (SP2) , Our SQL server agent showing green light as started from EM , It is succussfully restarting from NT Services too . But When I open the properties of the jobs from EM its gives error message SQL DMO error " SQl Agent is starting , try later " . And in EM Next run Date & Time not available .
MDDB database is accessable & in Log file its recovered fully
Thankx in Advance
Sha
View 1 Replies
View Related
May 3, 2008
Server A = primary SQL DBs (mirroring origination)
Server B = failover SQL DBs (mirroring destination)
For database mirroring a witness is required.
Can the witness live in another instance of SQL on server B?
View 7 Replies
View Related
Oct 12, 2015
Using SQL Server 2008, we would like propose mirroring between two servers of a critical database. Since we initiate, may require to clarify on its purpose and also required changes from application end.Any changes required from OS Level? (I believe both servers IP or Host name should be added in host entries. Mirroring ports should be allowed/open including Principal and mirror server IP Addresses): Windows Team.Any changes required from Application? (Instance name, authentication: user name and its password should be added in web config files): Application Team.Any changes required from Network Team?Also for mirroring both the principal and mirror servers should be with same version, does it only mean SQL Server 2008 versions are enough or does it also mean to say build numbers 10.00.4000 should also be same.URL....
View 5 Replies
View Related
Sep 15, 2015
I need to set up asyncronous data replication across two clustered instances of SQL 2012 across 2 Datacenters. Both the datacenters have a common domain however the vlans are different. There are only 3 small databases on the primary instance.
any issue in setting up mirroring in this case as vlans are different.
Operating system is Windows 2012.
View 2 Replies
View Related
Oct 16, 2001
I would like to create a job that wakes up every 5 minutes or so and stops any job that has been running for, say, more than an hour.
Alternatively, when it is a jobs scheduled time to run, if the job is already running, I would like it to stop the previous execution and start over.
Thanks
View 1 Replies
View Related
Dec 3, 2002
Hi, I am unsure whether i can delete some system created tables from a database.
I was testing replication and then used the wizard to disable it all. I am however left with three tables that are replication based that have not been deleted. they are :
MSreplication_subscriptions
MSsubscriptions_agents
MSsubscriptions_properties
these tables are causing problems with some third party software due to the length of their names. I have tried to 'Exec sp_rename' but i get an error saying the objects are not valid for this operation.
Can i just delete them or will this cause problems if i want to start up replication in the future?
View 2 Replies
View Related
Jul 13, 2004
Quick question...
I was under the impression that RAISERROR stopped excution in my DTS SQL Task, but it really just passes right over it.
For example:
RAISERROR('test error',19,1) WITH LOG
CREATE TABLE delete_me (data int)
Even though I rasie the error, the table still gets created. Any ideas on how I stop the task from going to the next line?
View 1 Replies
View Related
Mar 31, 2008
I'm trying to stop a SQL Server Agent Backup job if it is running past 7 a.m. Can you reply with your ideas.
Thanks.
Deb Dawicki
Sansum Clinic
System Administrator III
805-692-6422
View 1 Replies
View Related
Jul 23, 2005
In query analyser, I can stop a script with the "return" statement butif the script contains multiple batches (separated by GO) then thereturn statement only stops the current batch.Is there a way to stop the whole script?
View 2 Replies
View Related
Jul 20, 2005
Hi,Please look at the code at the bottom of this procedure (UPDATECOVENANT PRINT DATE). When I put it at the tope of this section, itdoes the update and fails to return the SELECT results. When I put itat the bottom, the SELECT returns results and the UPDATE fails.Can anyone suggest what might be causing my problem?Thanks/************ SPECIFIC PROGRAM SEARCH ************************/IF @PRG_ID != 0 -- PRG_ID suppliedBEGINSET @strWHERE = 'WHERE PRG.PRG_ID = ' + cast(@PRG_ID as varchar(15))EXECUTE (@strSELECT + ' ' + @strFROM + ' ' + @strWHERE + ' ' +@strORDERBY)RETURN(0)END/************ NON-SPECIFIC PROGRAM SEARCH ************************/IF @ORG_ID != 0 -- Add ORG_ID to whereIF @intAND = 0BEGINSET @strWHERE = @strWHERE + 'ORG.ORG_ID = ' + cast(@ORG_ID asvarchar(15))SET @intAND = 1ENDELSEBEGINSET @strWHERE = @strWHERE + ' AND ORG.ORG_ID = ' + cast(@ORG_ID asvarchar(15))ENDIF @PRG_Closed != 2 -- Add PRG_Closed to whereIF @intAND = 0BEGINSET @strWHERE = @strWHERE + 'PRG.PRG_Closed = ' + cast(@PRG_Closedas varchar(15))SET @intAND = 1ENDELSEBEGINSET @strWHERE = @strWHERE + ' AND PRG.PRG_Closed = ' +cast(@PRG_Closed as varchar(15))ENDIF @strWHERE != 'WHERE '-- if some parameters supplied..BEGIN-- Execute searchEXECUTE (@strSELECT + ' ' + @strFROM + ' ' + @strWHERE + ' ' +@strORDERBY)RETURN(0)END/************ UPDATE COVENANT PRINT DATE ************************/-- Added by JSHAW 02/25/2004IF @PRG_Covenant != 0 -- PRG_Covenant suppliedBEGIN--SET @ORD_Date = GETDATE()UPDATE PROGRAMSSET Covenant_Printed = convert(char(10),@ORD_Date,101)WHEREPRG_ID = cast(@PRG_ID as varchar(15))ENDGO
View 1 Replies
View Related
Oct 16, 2006
Hi Forum, I want to stop insert data if value already entered in Column, Im used to .mdb and am new to .mdf much thanks Paul
View 14 Replies
View Related
Dec 13, 2001
Anyone got any "gotchas" or "nightmares" they want to share out of experience where the services have been shutdown without the proper forethought?
I'm trying to put a case in for a SQL DBA to be paged and to be in charge of shutting down the services and/or put together a checklist of things to verify first.
While I realize shutting down the services is supposed to be a graceful shutdown process I'm willing to bet there are a host of considerations.
Appreciate any Input.
Regards
View 1 Replies
View Related
May 29, 2002
How do you start/stop a service within a sql script?
View 2 Replies
View Related
Oct 31, 2000
hi,
i am having sql7 with sp2.
Recently our server got bounced back. No body stopped the server, there are no work load at that time. Server suddenly stopped and started.
It is weired.
Can anyone have any clues , how it happened and why it happened.
Thanks!
__kavira
View 3 Replies
View Related
Oct 26, 2000
Recently upgraded a 6.5 server to a 7.0 server. (same server)
When we try to stop the 6.5 service, the 7.0 service stops too.
Why is this happening? Aren't the 6.5 and 7.0 installations supposed to be independent of each other once the upgrade is done.
Further we would like to uninstall the 6.5 server from the machine as it is no longer being used. What considerations need be taken into account in our scenario.
Thanks
View 1 Replies
View Related
Jan 16, 2001
I've been running SQL Server for 5 years now and have not seen the following.
We have a scheduled night run task where we do various maintenance functions as well as print out the issued insurance policies for the day. All indications are that the run completed except that I did not get an email notification of success or failure.
When I went to enterprise manager, under jobs the night run seems to be stuck in the mode of "Performing completion actions". I cannot get it our of this mode back to "Not running". Trying to stop the task has no effect.
Any ideas/suggestions??
Thanks in advance.
Cheers,
Mike Byrd
Information Systems Manager
Texas Windstorm Insurance Association
Austin, Texas
View 6 Replies
View Related
Nov 9, 2005
What is the command to stop a stored procedure from continuing to run? I have a procedure that has a problem, and due to a bug it runs wild in some scenarios, so I need to be able to stop it.
View 8 Replies
View Related
Mar 28, 2004
Hi,
I have searched google and have found no real answer to this....
We are creating a database to support an application which is loading in data as part of the cutover from their current db to SQL Server.
The datafile is around 56GB and when the data processing occurs, as its not just inserts, the transaction logs fills out to around 65GB, and probably more, just that we ran out of space. So question is, is there a workaround for stopping the logging of this processing at all. I have seen that bulk-logged mode may be used, but the option with TABLOCK must be used, and there is no way to get hands on code which performs this processing.
Is there a way to turn off transaction loggin at any point?
Thanks,
Jim
View 7 Replies
View Related
May 7, 2007
I have a SQL Server agent that keeps stopping for no reason. It happens about every other day. I have to go in on the server and manually start it. What would cause this to happen? We have about 50+ computers that need to sync with the server and do so successfully without having to manually start the agent every other day. How do we fix it?
View 17 Replies
View Related
Sep 27, 2005
We have a console.php which takes in SQL queries and displays them in aresult.php webpage.Sometimes the query takes minutes to execute or crashes the PHPapplication. Is it possible to cancel a query during execution?If yes, how does one go about it.The PHP Console is used by multiple users simultaneously.The queries are executed on a Remote Database.
View 2 Replies
View Related
