Moving the store SQL database to a local install

Introduction Ok peeps, time to have fun with SQL 2005. Have you ever tried to backup a SQL database on one server and restore it to a local or different server install? Sometimes it works, other times it just melts down and you can't figure out why. You probably missed something I just spent the last 5 hours missing.... WARNING: This is some advanced SQL stuff, make backups and use caution Schemas SQL 2005 has a feature called schemas. What is a schema? Don't ask. Suffice it to say, a schema can ruin your day if you're trying to move a database. Let me explain. Have y...

Aug 02, 2008 READ MORE