meta user
network profile
| bio | website | qcumberland.com |
|---|---|---|
| location | Houston, TX | |
| age | 37 | |
| visits | member for | 2 years, 1 month |
| seen | Jun 15 at 0:00 | |
| stats | profile views | 42 |
|
May 30 |
comment |
SQL Server 2008r2 Enterprise evaluation expired - Options? I can confirm that the "this approach with scripts" method works well if you can take the outage. I've used this method several times and as long as the instance name and paths are installed the same as before you should be good. |
|
May 22 |
comment |
SQL agent job step's connection managers That's a good thought, put that in as another answer. |
|
May 22 |
comment |
Dropping Hypothetical Indexes How about a screenshot of what a hypothetical looks like? |
|
May 21 |
answered | SQL agent job step's connection managers |
|
May 20 |
comment |
Auditing specific database events If moving from Enterprise to Standard then check on the differences in SQL Server Audit between the editions; there are EE only features. |
|
May 20 |
answered | Should we periodically 'refresh' the mirrored copy of a SQL Server database? |
|
May 14 |
awarded | Caucus |
|
May 1 |
answered | Indexes file damaged, was on ramdisk |
|
Apr 25 |
awarded | Yearling |
|
Apr 23 |
comment |
Can I shrink the transaction log file on a mirror database? Hope no longer. Once the database gets suspended/disconnected and a log backup gets executed on the primary you are pretty much hosed on getting the mirror back in synch without a re-init. |
|
Mar 27 |
comment |
Run Multiple Remote Jobs Gotcha, user's needs are what they are. :) |
|
Mar 26 |
answered | Run Multiple Remote Jobs |
|
Feb 21 |
comment |
SQL Server connection failed for domain user from Mac OS machine Use connectionstrings.com (connectionstrings.com/sql-server-2008) to show you different connection string configurations, specifcally around Integrated Security. The problem with doing it from a Mac is that it doesn't tie into Active Directory that I know of so it is not likely to work and you will need to use standard (SQL) security where you specify the username and password. |
|
Feb 21 |
comment |
SQL Server 2012 defrag job runs interactively, but not as a job - why? Try changing the job owner to "sa" and see if you get the same result; that will run it under the service account context. Also check the procedure to see if you are using an "execute as" in the DDL. |
|
Feb 15 |
comment |
SQL Server connection failed for domain user from Mac OS machine If you are specifying a username and a password in the connection string then you are not using AD/Kerberos security. Those fields in a connection string are used for SQL authentication. You need to run the process under the domain account, which I have no idea how you would do on a mac. |
|
Dec 4 |
awarded | Revival |
|
Nov 16 |
comment |
SQL Server connection with multiSubnetFailover fails, claims mirroring is enabled Did you make sure to run alter database d set partner off on both the primary and the mirror? AG uses mirroring to keep the replica up to date but it doesn't play so well with mirroring. What I have been doing is set up mirroring between the instances to get them in synch, remove it from both sides and then set up the AG. I'm not sure about the multisubnet setting in JDBC. |
|
Nov 9 |
comment |
How to recover a corrupted msdb database in SQL Server 2008? If you installed the instance to the same directory as the previous install you can just replace the MDF/LDF files for msdb and the jobs should be there when you bring the instance back up. You should not need to remove the LDF file at all. |
|
Oct 1 |
comment |
Could not find the Server Agent in SSMS You also have to make sure that you are not using the Express version of SSMS, and that you have sysadmin rights to the instance, or the proper roles in the msdb database. |
|
Aug 30 |
comment |
uninstalling SSRS and SSIS from clustered SQL Server 2008 R2 SP1 So did this work for you Albert? |
