Archive for June, 2011
Error: “The file … cannot be moved by this RESTORE operation.”
This morning, I was trying to restore a database from a SQL 2005 backup to a new server. The restore involved a full backup and a differential. I restored the full backup with NORECOVERY via SSMS, but when I tried to restore the differential, also via SSMS, I got this error: Okaaay. I was a [...]
June 21, 2011
Tags: differential backup, differential restore, error Posted in: Troubleshooting 
6 Comments
What I’m working on
This has been a somewhat scattered week. As I alluded to earlier, my mind has been pulled in all different directions after a week of training and listening to presentations. I really have to work on writing my ideas down somewhere, as I have them, and getting them out of my head until I’m ready [...]
June 16, 2011
Tags: presenting Posted in: General, Professional Development One Comment
The problem with SQL Saturday…
The problem with user conferences is that they usually leave me with a slight case of ADD the following Monday. So much stuff, I have to try it all NOW!!! SQL Saturday #75 this past weekend in Columbus was no exception. There were some really good presentations and for a couple time slots it was [...]
June 13, 2011
Tags: professional development, SQL Saturday Posted in: Professional Development No Comments
Stuff I learned today – XML and CLR
Well, to say I “learned” about XML and CLR is a bit disingenuous. More accurately, the instructor went over XML and CLR. But to be honest, I know so little about either subject that it was a bit like listening to Charlie Brown’s teacher. But anyway, we covered it and it gave me some ideas [...]
June 10, 2011
Tags: SQL Saturday, xlr, xml Posted in: Features, General, Professional Development No Comments
Stuff I learned today – Table Types
Since SQL Server 2000, you’ve been able to create variables of type TABLE, but you needed to define that table structure when (and each time) you declared the variable. You also couldn’t pass these table variables into a stored procedure. SQL Server 2008 introduced the user-defined TABLE datatype. Now you can create and store custom-made [...]
June 8, 2011
Tags: SQL 2008, Table types Posted in: Features, T-SQL No Comments
