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 |
|
gshegog
Starting Member
1 Post |
 Posted - 2006-06-05 : 08:10:48
|
| Help!I have a customer who I have set up a SQL Server Express database for. The database was running fine, but I copied it over to my pc over the weekend to update some data. I have copied the data backwards and forwards plenty of times, but this time when I came to copy it back and reattach it on the customers' server I get the following message:TITLE: Microsoft SQL Server Management Studio Express------------------------------Attach database failed for Server 'SBSSERVER\BKUPEXEC'. (Microsoft.SqlServer.Express.Smo)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)------------------------------Could not find row in sysindexes for database ID 6, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.Could not open new database 'ACServe'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)This is REALLY urgent.Help me pleaseGabby |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-05 : 12:27:00
|
| You might want to consider BACKUP / RESTORE in future.It may just be a duff copy of what's on your local machine.Take a backup of your local copy (if you don't already have one)Run DBCC CHECKDB on the database on your machine to check its OK, if so try recopying it.Make sure you have an automated backup strategy on BOTH machines so you don't get hosed if the DETACH/ATTACH process breaks for any reason.Kristen |
 |
|
|
|
|
|
Copying SQL Server Express Database