Reputation
1,752
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
8 6
Newest
 Yearling
Impact
~664k people reached

  • 0 posts edited
  • 0 helpful flags
  • 24 votes cast
May
31
awarded  Yearling
Mar
6
comment ADSI Linked Server: Why can I query AD in VBA, but not as a Linked Server?
I've always found the 'LDAP' portion of these queries hard to grok. I can't tell you why VBA works and your TSQL does, but I can get a similar query to work on my 2008R2 instance if I change 'LDAP://dc=testdomain' to 'LDAP://testdomain'
Sep
26
comment Sql Server Transaction Log Backup Fails
Have you looked in the SQL Server log, the Windows event logs and the software for the RAID controller for filesystem-level problems, problems reading blocks, etc. Also, have you double-checked the file permissions on that file?
Sep
24
answered Sql server transaction timeout
Jul
23
comment How to locate the cause of a excessive memory in ms sql
In 16 years of SQL Server experience, I've seen more memory leaks in monitoring software than in SQL Server itself. How much memory is in your server, in total? How much RAM is used by the Windows OS and other programs and services? Are you sure that the memory is not defective? (Is it a new machine, have you added memory lately? If it's an old machine, have you blown the dust out of it or re-seated the RAM modules lately?) Is there anything in the SQL log or event logs that gives a hint as to what causes the crash? Are there memory dump files?
May
31
awarded  Yearling
Sep
11
answered SQL Server queries running more than the timeout values set in IIS 7.5 and SQL Server query timeouts
Aug
16
answered Using SAN Replication/Snapshots for SQL Server disaster recovery?
Jul
11
comment Backing up database fully from remote server, and restoring to another remote server
The disk clause of a RESTORE command takes UNC paths, and drive mappings tend to get confused since they are per-user and not per-machine. (IOW, the X: that you see might not be the X: that the SQL instance sees if it sees one at all.) So, rather than "DISK = 'X:\MySiteDB.bak'", you can use "DISK = '\\PRODMACHINE\BACKUPSHARE\MySiteDB.bak'". This presumes that your SQL instances are domain accounts, running with enough read/write permissions on those files and shares. Also, don't share out the root of your C:, make a folder to put the backups into and share that to minimize the attack surface.
May
31
awarded  Yearling
Apr
26
comment MSSQL Datafile on DFSR
All of the above, but it's even worse than that. If your solution isn't backing up your LDF file, you don't have a solution. SQL Server relies on being able to read the LDF when the 'other' nodes starts up after a failover. Not all committed transactions are immediately written to the MDF file. They may only be in the LDF file. If you don't have a good copy of the LDF file, you may loose transactions that the database claimed were committed.
Apr
22
answered In sql-server, how do I give server-level permission to user to make backups on any database
Apr
22
answered SQL Server doesn't archive logs
Feb
25
comment Can I move all DB files on SQL server 2008 to a different logical drive and then change the drive letter?
+1 for this method. I've this many, many times. The only thing is that you want to be sure to copy the security ACLs for the files and folders onto the new drive as well or the server may not be able to open the files.
Feb
19
answered Azure Table Storage mirroring
Feb
14
comment SQL Server Replication Requires the actual server name
Possible duplicate: stackoverflow.com/questions/8212032/…
Feb
13
comment if I select more than 15 fields, I get catastrophic failure
1st hit from google: social.technet.microsoft.com/Forums/da/winserverpowershell/… His powershell script uses System.Data.Odbc and tries whatever connection string you provide. You need to replace the values of the $connectstring and $sql variables with something that fits your situation. The $sql variable is up to you. Getting $connectionstring is a little trickier. connectionstrings.com/pervasive gives a "standard" Pervasive ODBC string as Driver={Pervasive ODBC Client Interface};ServerName=myServerAddress;dbq=@dbname;
Feb
11
answered How do I log in, using SSPI, to SQL Server 2008 R2 on a server in one workgroup from a workstation in another?
Feb
11
comment if I select more than 15 fields, I get catastrophic failure
Another troubleshooting trick I use is to write a small program that I can run directly on the server (using vbscript or powershell; there are many examples to be found through google) that uses the driver to see if I can run the same query outside of the SQL Server Linked Server scheme. Sometimes, I find that the problems are login-related (ie. my account versus the SQL Server service account), sometimes the error messages are a little more detailed.
Feb
10
comment if I select more than 15 fields, I get catastrophic failure
Is the problem related to the number of columns you select or to one particular, problematic data type? IOW, using your example, perhaps the driver has a problem with the data type of field3 and SELECT field1,field2,field4 ... might work. Does SELECT field3 by itself work OK?