Tag Info

New answers tagged

4

Please don't detach and attach your database. If you detach it and something happens to it, you now have zero copies of your database. Much safer approaches: Backup/Restore USE master; GO BACKUP DATABASE floob TO DISK = 'c:\wherever\floob.bak' WITH INIT, COPY_ONLY; ALTER DATABASE floob SET SINGLE_USER WITH ROLLBACK IMMEDIATE; RESTORE DATABASE floob ...


3

I will post it as an answer because it doesnt fit in the comment: What you need to do is detach the database, move log file to a new location, and atach again referencing the new location of the transaction log file. I will not post an answer because i never did this, but I know this is how it works. You can find a lot of information on google. And yes, you ...


1

If you are using innodb tables, try to raise innodb_buffer_pool_size as much as you can. You must balance the ram from mysql and other tools you use for development. The idea is to don't have a swapping machine and to use memory resource as best as possible.


1

It looks like the current MongoDB 3.0 upgrade instructions are missing mention of two important parameters for backing up and restoring users and roles: mongodump --dumpDbUsersAndRoles (see also: Required Access to Backup User Data). mongorestore --restoreDbUsersAndRoles (see also: Required Access to Restore User Data) I can think of several approaches ...


5

The not-so-good news is that I have done a lot of searching on this topic, only to find that over the years a lot of others have done a lot of searching on this topic, and there is no way to configure the behavior of SqlClient. Some MSDN documentation implies that it can be done via a ConnectionString, but there are no Keywords that would allow for altering ...


2

There is no setting to force SqlClient to always set ARITHABORT on, you have to set this as you describe. Interestingly from the Microsoft documentation for SET ARITHABORT: - You should always set ARITHABORT to ON in your logon sessions. Setting ARITHABORT to OFF can negatively impact query optimization leading to performance issues. And yet the ...


1

I recommend using @Mike's awesome Powershell script. However as an alternative if your SQL Servers are 2008R2 SP1 or latest and if you have list of servers registered under "Local Server Groups" or "Central Management Servers" you can run use the following query to get service status info: SELECT servicename , startup_type , ...


5

I would use Powershell for this task. Here's a function that leverages Get-WMIObject, WQL, and some syntax to take a list of servers to analyze. function Get-SQLServiceInfo{ param([string[]] $servers) $return = @() $wql = "SELECT * FROM Win32_Service WHERE name like '%SQL%' and (startmode != 'Auto' or state != 'Running')" foreach($server ...


4

Option 1 Aside from Sankar's solution, setting the arithmetic abort setting at the server level for all connections will work: EXEC sys.sp_configure N'user options', N'64' GO RECONFIGURE WITH OVERRIDE GO As of SQL 2014 it's recommended to be on for all connections: You should always set ARITHABORT to ON in your logon sessions. Setting ARITHABORT to ...


0

I don't consider it dead. You can easily roll it out across large numbers of servers and have those policies enforced on each instance. I don't think it's about to disappear, but I can't comment for Microsoft.


0

If you just want to have central reporting, take a look at https://epmframework.codeplex.com With this you can check your servers centrally against one policy store.



Top 50 recent answers are included