11
votes
How to update a CLR Assembly without dropping assembly from SQL Server
To add to Ben Thul's answer, this can be accomplished remotely fairly easily via SQL Server Management Studio's GUI.
Under the Object Explorer for your database -> Programmability, right click on ...
- 111
4
votes
Build mirroring on top of SQL2008R2 SQL cluster
This article explains the issue pretty well: https://technet.microsoft.com/en-us/library/ff658546(v=sql.100).aspx.
I am using Failover Clustering for most of my highly available DBs (both Oracle and ...
- 6,151
3
votes
Accepted
Manage SQL Agent Jobs On Multiple Servers
Yes.
Go to View -> Registered Servers.
Go into Database Engine -> Local Server Groups and create a new server group. Add all the servers you want to that group.
Highlight the group, then right-...
- 18.6k
3
votes
MS Native SQL driver 10.0 and SQL Server 2008 connection creation failure
Check if the issue exists on the localhost of the server to eliminate the possibility of it being network hardware causing the timeout. Assuming the issue goes away when you test on the localhost, ...
- 1,859
3
votes
Accepted
SQL Server, local instance, No process is on the other end of the pipe
After double-checking the parameters I choose when reinstalling, I realized that Mixed-mode wasn't checked, only Windows authentication mode.
Following the instructions to this link fixed my problem: ...
- 173
3
votes
Ola Hallengren's SQL Backup to Network Location not working
I was diagnosing a similar issue implementing Ola's scripts. It would work on some servers and not others. I would get:
"Msg 50000, Level 16, State 1, Procedure DatabaseBackup, Line 395 XXX The ...
- 139
2
votes
Accepted
How to update system databases in SQL Server
In order to update sys.brickfiles manually, you're required to use the Dedicated Administrator Connection. This is available via SQLCMD; you just need to type ADMIN: before the servername.
[Insert ...
- 18.6k
2
votes
Migrate MSSQL 2008R2 to 2012 (new hardware)
Assuming I don't want any new features of 2012 is it as easy as
restoring the 2008 databases on the new server?
It is - plus setting trace flags for the server to force the old behavior of the ...
- 51.4k
2
votes
Accepted
Seting local MSSQL Server as Database Server
I think I have some idea what you might want to do... I think you might be asking how you can have a website you host target an arbitrary MSSQL server.
There isn't really a good way to do that. You ...
- 25.1k
2
votes
sql server can't start error code 1814
2018-05-02 16:32:47.80 spid10s FCB::Open failed: Could not open file e:\sql10_main_t.obj.x86fre\sql\mkmastr\databases\objfre\i386\model.mdf for file number 1. OS error: 3(The system cannot find ...
- 145
2
votes
Accepted
What to do with an old windows 2008 r2 server with old windows updates
Fortunately, Microsoft stopped releasing updates the way they did back then, so a system doesn't need to install 300+ updates.
For the base operating system, all you need is the most recent servicing ...
- 35k
2
votes
SNMP and SQL Server, is it possible to store the alerts in sql server without using any program?
SNMP is a protocol. Your legacy system is polling or receiving SNMP from what it's monitoring, and then storing that in SQL. The monitoring system is a program, it doesn't need an additional program ...
- 35.9k
1
vote
Accepted
Are SQL Server Compatibility Levels Transparent to the Client?
The official stance from MS seems to be "this is fine". Specifically, they speak to it here.
From the link (for posterity):
Database Compatibility Level is a valuable tool to assist in ...
- 3,004
1
vote
MS SQL 2008 R2 disaster restore
Consider NOT restoring the system databases. Just restore the data containing files, and hopefully someone was smart enough to make them contained (so they contain the users).
- 51.4k
1
vote
Accepted
Need to add a login to a database for SSMS (Sql server) 2008 r2
You can also use T-SQL to create logins. Please see this link Event though it states is for SQL 2017 it should work for your version too.
EXAMPLE (from linked URL): CREATE LOGIN WITH PASSWORD = '';
...
1
vote
SQL: server 2008 database stuck in Restore
So, you only have two options in a log shipping configuration. One is where the database on the secondary is in a "read-only" mode where reads can occur on the database until the next log is restored,...
- 431
1
vote
how to update SQL Server 2008 to 10.50?
You downloaded the wrong thing. What you tried to install was service pack 1 for SQL Server 2008 R2. Upgrading from 2008 to 2008 R2 isn't a service pack. It's a completely different version - like ...
- 768
1
vote
Need to reset the SA password on our SQL 2008 R2 server. Will it break things?
Depends if anything is using it - nothing should be using it (AFAIK), like no services should be running as a domain administrator, but only you can say for sure in your environment.
I think your ...
- 5,696
1
vote
Issue installing SQL SERVER EXPR 2012/2016 on Server 2012 R2
I would consider posting this as a comment but due to a lack of rep, i can't.
Try moving the SQL database files (.mdf and .log) to a new Windows VM, and upgrade the database files there. Then ...
- 309
1
vote
Accepted
What kind of SPN is required to delegate client credentials to a SMB Share?
Yes that is correct, it would be 'cifs'.
- 71
1
vote
The MSDTC transaction manager was unable to push the transaction to the destination transaction manager due to communication problems
It turns out that we had Symantec Endpoint protection pushed the week before. I totally forgot that it was right before I left for the weekend.
That was blocking the DTC traffic, but weird that it ...
- 111
1
vote
2K8 Cluster - SQL Instance broken on one node
You need to run your SQL Setup again on node2 after installing a new cluster on node1. Select the option 'Add a node to a SQL Server failover Cluster'
(screenshot from 2012, but the process is the ...
- 17.8k
1
vote
Accepted
SQL Server 2008 R2 connection sometimes fails with 'incorrect login'
First issue: login failed error.
Your database is most likely not fully initialized yet when the tests run.
You should catch this in your procedure, an easy way to do this is to query the master ...
- 5,587
1
vote
SQL Server 2008 R2 does not utilize allocated memory
Max server memory means that your server cannot use more than that amount, not that it must use that amount. Min server memory doesn't mean it must use that amount, either; it means that once the ...
- 18.6k
1
vote
Migrate MSSQL 2008R2 to 2012 (new hardware)
First off, as TomTom already stated, yes it is possible.
Using a backup / restore procedure is the proper way to upgrade your database.
However, you will still need to do some other actions.
You will ...
- 5,587
1
vote
Minimal required user permissions for running MS CRM
You should be able to safely remove both permissions for the CRM app pool. However, please take the following into consideration.
First you need to understand why Microsoft and CRM require those ...
- 61
1
vote
cannot restore database to a different version of MSSQL server
Based on the build numbers you've provided, the original computer was running an updated version of SQL Server 2008 R2 RTM, while the newly installed version is SQL Server 2008 R2 Service Pack 3.
Try ...
- 9,250
1
vote
Can't login to SQL Server in Single User mode
I just had this exact problem and all that I had to do was:
Stop the main SQL service for my instance.
Start it.
I reconnected SQL browser and it worked again. So instead of trying all the extra ...
- 111
1
vote
Activity monitor is unable to execute queries against server
I thought I would post my experience with this issue.
Symptoms - SQL Server 2008 R2, on Dell machine, suddenly suffered huge performance degradation. User applications became very slow when ...
- 11
Only top scored, non community-wiki answers of a minimum length are eligible