1,798 reputation
313
bio website stuart-moore.com
location Nottingham
age
visits member for 1 year, 11 months
seen 9 hours ago

Nottingham based DBA, mainly SQL Server but turns hand to anything else. Currently getting excited about cloudy stuff.


Nov
20
awarded  Enlightened
Nov
19
awarded  Nice Answer
Nov
19
answered Backup SQL DataBase to C$
Nov
19
answered SQL Server 2008 R2 DDL Trigger to create DML Triggers on all new user tables
Nov
16
revised Create job to send alert using sp_send_dbmail when table value greater than x
forgot last line of answer, now added so it makes sense
Nov
16
answered Create job to send alert using sp_send_dbmail when table value greater than x
Nov
15
revised SQL Server: Simple database restore with overwrite
not happy with phrasing.....
Nov
15
answered SQL Server: Simple database restore with overwrite
Nov
14
revised How define select, if bridge pair may have 3 players?
grammer and tidied up generally
Nov
14
suggested suggested edit on How define select, if bridge pair may have 3 players?
Nov
13
revised tempdb usage in SQL Server
reformatted code for clarity
Nov
13
suggested suggested edit on tempdb usage in SQL Server
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