Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
steelkilt
Constraint Violating Yak Guru
255 Posts |
 Posted - 2005-08-12 : 16:50:11
|
| I'm running some tests on my failover SQL 7.0 server.I detached a database from my main server, copied it the hard disk of the failover server, and then tried to attach it.Got this error:Server: Msg 945, Level 14, State 2, Line 1Database 'MAINDB' cannot be opened because some of the files could not be activated.Server: Msg 1813, Level 16, State 2, Line 1Could not open new database 'MAINDB'. CREATE DATABASE is aborted.Any ideas what's going on? I've tried with plain old sp_attach_db as well as sp_attach_single_file_db. I'm only attaching MDF.thx |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2005-08-12 : 17:08:06
|
| As just a silly "check the wires" kind of check, are all the paths to the files good? Maybe permissions on the directories? How many files are there in the database? |
 |
|
|
steelkilt
Constraint Violating Yak Guru
255 Posts |
Posted - 2005-08-12 : 17:26:49
|
| yeah, paths are good, I'm the admin with full permissions.Haven't checked the number of files within, seems like an odd error, the MDF file is 500mb, doesn't seem to huge to me. hmmmm... |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-08-12 : 19:19:08
|
| Why are you only attaching the MDF? Does it work okay if you attach ALL the files?---------------------------EmeraldCityDomains.com |
|
|
|
|
|
|
|
|
detach db, copy to another server, can't reattach