Shut Down
Sep 15, 2004hi
can i shut down MSSQL Server whn any transaction is active?
ADVERTISEMENT
Everything That Will Cause A Queue To Shut Down
May 22, 2007
I have a queue that, after running fine for several days will mysteriously turn off. It doesn't seem to be related to a poison message because I can restart the queue and processing resumes just fine. What are all the scenarios that would cause a queue to turn itself off, so I can 1) take preemptive action to prevent it from happening in the first place and 2) respond appropriately when it occurs.
Also, how to properly setup and verify that the BROKER_QUEUE_DISABLED is working properly. This is the SQL that I have so far, but is there a more direct way to raise the event other than writing an activated stored procedure that rolls back 5 times?
CREATE QUEUE [EventNotificationsQueue];
GO
CREATE SERVICE [EventNotificationsService]
ON QUEUE [EventNotificationsQueue]
([http://schemas.microsoft.com/SQL/Notifications/PostEventNotification]);
GO
CREATE EVENT NOTIFICATION [QueueDisabled]
ON QUEUE [MyQueue]
FOR BROKER_QUEUE_DISABLED
TO SERVICE 'EventNotificationsService', 'MyDatabase';
GO
Cannot Shut Down VS After Using Report Designer
Jan 27, 2006Routinely when I use BIDS to work on a report design, I cannot close BIDS because I get a message box that says:
Microsoft Visual Studio cannot shut down because a modal dialog is active. Close the active dialog and try again.
Of course, there is no visible dialog open. I actually have to terminate the process from task manager.
I do not get this problem when using SSIS or SSAS. Only SSRS.
Any Ideas?
Thanks!
BobP
Identity Out Of Sync After Unexpectedly Shut Down
Jan 11, 2000I have 2 DB on SQL Server 7, that are synchronized by a continuous transactional replication.
The tables have a primary key on an identity column. In order to avoid conflicts,
the identities have different seeds, and increment equal to 10.
When the server shuts unexpectedly, the current value for the
identity column goes out of sync, that is it assumes the greatest value inserted.
The workaround is to run DBCC checkident to correct the identity value.
Is it a bug? Did anyone run in the same problem?
TIA
Tania
Who Shut Down This Server? (was General Question (I Think))
Jan 26, 2005Is there a way to tell who the guilty person is:
The process winlogon.exe has initiated the shutdown of computer DOCSITE01FDK on behalf of user NT AUTHORITYSYSTEM for the following reason: Application: Maintenance (Planned)
Reason Code: 0x84040001
Shutdown Type: shutdown
Comment:
It tell you that the source is user23. Is there a way to determine who shut down this server?
Thanks
How To Shut Down BACKUP APPEND Mode?
Jun 13, 2007Hi All,
I got a job which runs every day this T-SQL code:
BACKUP DATABASE [myDB] TO DISK = N'f:BACKUPSDailymyBKUP.bak' WITH NOINIT , NOUNLOAD , NAME = N'mybackup', NOSKIP , STATS = 10, NOFORMAT
It runs just fine but in append Mode (the default one); the bak file is being taped every night, so I would like to overwrite it, in order it not to become huge after a few time, but I can't seem to find a clear way to do this.
Any help or pointing would be appreciated!
Cheers,
Giovanni
Modal Window Is Active Cannot Shut VS
Nov 26, 2007Hello,
While tryign to edit the XML for the rdl , i am stuck it will not allow me to edit and i have to kill the devenv process and open vs again.
I looked through some of the threads and tried apply KB 936971 Hot Fix and I am running into the following error.
The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch."
Did any one come across this. Any assistance would be greatly appreciated
Thanks,
SqlNew
Sp_procOption Vs. Autoexecution Before Server Shut Down
Jul 19, 2007
I understand using sp_procOption procedure we could set procedure for autoexecution every time an instance of SQL Server is started. I would like to find out if there is any way for me to run a procedure before server shuts down.
I am interested to collect statistical data from DMV before SQL Server is restarted due to DMV's transient nature. I am sure some of you would suggest having a job running that collects data from DMV's periodically. But ideally I would like to collect data only once for server uptime.
I would appreciate any suggestion.
Thanks,
Asaf
Although Job Was Running In Background Cancelled Due To Power Shut Down
Nov 5, 2007Hi,
I am running two jobs background using SQL agent. There was a power shut down and the two job i was running in back groung were cancelled leaving the below message
The job was stopped prior to completion by Shutdown Sequence 0.
Can any one tell me why this happened although I am running them in back ground.
I am not sure where the servers are located and if they are located in the same bulding .. do u think it is bcoz of tis power shut down only?
Server Must Shut Down In Order To Recover A Database
Oct 7, 2015I know that there was huge tempdb usage and may be the disk was full but SQL server is not suppose to restart in this case.What could be the reason behind this? SQL server restarted and is currently up and running.We are using SQL server 2008 SP3
View 10 Replies View RelatedError On Server : The Log Cannot Be Rebuilt Because The Database Was Not Cleanly Shut Down.
Mar 18, 2008When I upload my website on to server I have the following error: Could not open new database 'edmer-kiem.qsh.es_b5711d30-4f2a-4151-a958-9f63adb9c1bf'. CREATE DATABASE is aborted.Cannot
attach the file
'H:HomeWebsqsh.esedmer-kiem_79170098-49d1-496b-b8ac-24e9f04837a4wwwApp_Dataedmer_kiem.mdf'
as database 'edmer-kiem.qsh.es_b5711d30-4f2a-4151-a958-9f63adb9c1bf'.File activation failure. The physical file name "C:Inetpubwwwrootedmer_kiemApp_Dataedmer_kiem_log.ldf" may be incorrect.The log cannot be rebuilt because the database was not cleanly shut down. I have searched forums but I could not solve it.. How can I shut down database on the server?Please help..
Microsoft Visual Studio Cannot Shut Down Because A Modal Dialog Is Active
Nov 17, 2006if i get this message one more time I am going to put my fist through my monitor
View 114 Replies View RelatedRecovery :: Access To Files On Shared Drive When Cluster Is Shut Down?
Aug 31, 2015Is there a way to get access to the files on the shared drive from either of the nodes when the SQL Cluster is shut down?
It doesn't look like there is, but hoping there is some trick. I see how it can be done with a Windows Cluster but not a SQL Cluster.
Microsoft Visual Studio Cannot Shut Down Because A Modal Dialog Is Active - Any Updates?
Jan 22, 2008I installed the hotfix available at support.microsoft.com/kb/936971 and even rebooted the server, but I am still getting the error. I am working on a Windows 2003 server with SQL Server 2005 (and reporting services). I am not trying to publish any reports using SSRS. I'm just working on designs and saving them. Any help for this at this point?
Leigh
When Debugging, Do You Have To Shut Down And Restart BIDS Every Time You Rebuild The Custom Component That You're Debugging?
Jul 9, 2006Hi,
I have found that when I'm debugging a custom component in BIDS that I've created in another instance of Visual Studio, every time I rebuild the component I have to shutdown and restart BIDS and then reattach to the BIDS process. Which is pretty time consuming... And if I find a small error in my custom component when debugging then I don't seem to be allowed to make any changes to the code unless I stop debugging and go through the process above.
Am I missing something here? Or do I really have to manually go through these steps every time I want to change code in the component I'm debugging?
Can I automate the process with MSBuild or NAnt? If so, is there an example of this anywhere?
Thanks in advance,
Lawrie.