meta user
network profile
| bio | website | leaf-node.co.uk |
|---|---|---|
| location | Nottingham | |
| age | ||
| visits | member for | 8 months |
| seen | May 17 at 14:16 | |
| stats | profile views | 26 |
Nottingham based DBA, mainly SQL Server but turns hand to anything else. Currently getting excited about cloudy stuff.
|
Nov 13 |
revised |
Restrict record to be update or deleted according to dates inside row for SQL Server 2005 fixed spelling and grammar, and hopefully made it a bit clearer. |
|
Nov 13 |
suggested | suggested edit on Restrict record to be update or deleted according to dates inside row for SQL Server 2005 |
|
Nov 13 |
comment |
Error in SSMS when attempting to restore a database You're welcome. And as @Marian mentions above, you'll probably want to check the other logging tables in msdb as it's likely they also contain 3 years worth of data ( sp_maintplan_delete_log , sp_purge_jobhistory and the sysmail_delete_* SPs detailed here - msdn.microsoft.com/en-us/library/ms177580(v=sql.105).aspx are probably worth investigating) |
|
Nov 13 |
answered | Error in SSMS when attempting to restore a database |
|
Nov 13 |
comment |
Error in SSMS when attempting to restore a database Possibly, what's the output if you run select COUNT(1), MIN(backup_start_date) from msdb.dbo.backupset on the problem server? (this will give us the 'amount' of backuphistory you've got atm, and how far back it goes). |
|
Nov 13 |
comment |
MySQL, import SQL dump with another database Which operating system are you running on? If it's a unix variant, then a tool like sed should have no problems replacing all`USE db1` statements with USE db2 ones (might take a while, but it'll do it). |
|
Nov 8 |
comment |
SQL Server Mirror failover on failing storage Is the corrupt tempdb on SQL-01 or SQL-02? |
|
Nov 8 |
answered | SQL Server Mirror failover on failing storage |
|
Nov 8 |
comment |
SQL Server Mirror failover on failing storage Is this the blog you're following? - sqlserverperformance.wordpress.com/2012/03/27/… - I'm wondering if it's because all the DBs are on the same 'failed' drive so the ALTER DATABASE in the sp is failing? |
|
Nov 8 |
comment |
SQL Server Mirror failover on failing storage Can you failover manually? When you disable the storage of sql-01 are the databases 'failing' and are you seeing anything in the SQL logs? |
|
Nov 8 |
comment |
SQL Server Mirror failover on failing storage Do you have a witness server? And are you running in High-Safety mode? Both are required for automatic failover ( msdn.microsoft.com/en-us/library/ms189590(v=sql.105).aspx ) |
|
Nov 8 |
answered | Finding delete or update records |
|
Nov 5 |
revised |
Database Indexing - Maintenance Jobs edited tags |
|
Nov 2 |
revised |
“Zero” downtime and minimal space requirements for upgrade to PostgreSQL 9.2 Clarified which RDBMS the question is about |
|
Nov 2 |
suggested | suggested edit on “Zero” downtime and minimal space requirements for upgrade to PostgreSQL 9.2 |
|
Nov 2 |
comment |
Group by collection_item_id and order by products.weight Hi Rory. Do you have some example data and a required output example? Currently it's a little ambiguous about what you'd like to return from the group by. For instance do you want to sort by the maximum weight in a collection_item_id, or the minimum, or the average, or the sum? |
|
Nov 1 |
comment |
Powershell script executing within SQL Server Agent Unfortunately that won't work unless you've already accepted the host key, as acknowledging the host key is seen as part of the secure connection method, as you're confirming that the host you've connected to is the one you expected (prevents man in the middle style exploits). |
|
Nov 1 |
answered | Powershell script executing within SQL Server Agent |
|
Nov 1 |
answered | How do I enable READ-only (passive) mode in a particular RDBMS? |
|
Oct 31 |
answered | Mysql database connector table or keys |
