This restriction makes sense only if the source and destination databases are the same, which could lead to overwriting data in-place. However, copying between different databases on the same instance ...

Microsoft uses the Database Campatability Level to make sure your applications continue to work even after an upgrade of SQL Server. There has been much confusion over this database property.

SQL Server lets you disconnect a database from the main server program, allowing you to make safe backup copies or send data to branch offices.

SQL Server database corruption is troublesome for DBAs, particularly if the situation arrives suddenly and there is no backup. This situation can lead to prolonged downtime and permanent data loss in ...

Procedure to move Microsoft SQL Server database to a new location, painlessly, if you’re running low on disk space, added a new drive array, or just curious.

Guys I have about 8 sql server 2000 databases that I'm moving to a new server. My problem is theres a lot of odbc connections out there thats point back to the old server. Besides naming the new ...

The SQL Azure Migration Wizard (SQLAzureMW) is a CodePlex project and wizard that can be used to migrate SQL 2005 and SQL 2008 databases to SQL Azure.