Viewing 10 posts - 1 through 10 (of 10 total)
You cannot detach a system database (master), (model), (msdb), (tempdb). Plus, let's be honest, these databases are typically very small in size as they house little information.
July 13, 2009 at 11:12 am
Your modification of the scripts look great. Keep in mind that all users must be out of the database before you can detach the database. After you detach...
July 13, 2009 at 9:44 am
USE MASTER
GO
SP_ATTACH_DB ‘ENTER_YOUR_DB_NAME_HERE’,’D:\NewPlace\ENTER_YOUR_DB_NAME_HERE.mdf’,’D:\NewPlace\ENTER_YOUR_DB_NAME_HERE.ldf’
GO
July 13, 2009 at 7:45 am
USE MASTER
GO
SP_DETACH_DB ‘ENTER_YOUR_DB_NAME_HERE'
GO
Move the database files to the new location, there will be two files with the database name, a .mdf and a .ldf....
July 13, 2009 at 7:44 am
MJ hit on it, after you rename SQL Server, you MUST restart the server.
March 5, 2009 at 7:41 am
You will definitely need to add, at the minimum, SP1 to the SQL Server. It had a very important fix regarding maintenance plans.
February 24, 2009 at 8:06 am
Have you verified the server name is the same in the database as it is in sysdatabase?
February 20, 2009 at 8:32 am
I have ran into this error during testing and found this to be the most effective remedy. Sometimes a table gets hung during an upgrade of a database (which...
February 4, 2009 at 9:05 am
Drop the table name and then stop/start SQL Server
February 4, 2009 at 8:47 am
The easiest way would be to backup the database(s) on the SQL 2000 box, move them to a temp directory (or offsite). Uninstall SQL 2000, install SQL 2005 with...
January 19, 2009 at 7:39 am
Viewing 10 posts - 1 through 10 (of 10 total)