I am attempting to reinstall from a windows gone bad problem.
XP had "died" and unable boot into os, so there was no backup or copy database made.
Have installed new hdd. copied most all of the old hdd to a "backup" folder on new hdd. I know of the program files ms sql data subdir.
System state.
XP professional , not sharing on network, so is like standalone pc.
sql is 8.0 ( the downloaded version that was part of the installation of a precreated data base.)
XP is now sp2 I do not think it was prior.
I copied the contents of the old data folder to the new folder, overwriting the install created db files.
error given when running data base is
This program cannot connect to your database file, cuttingedge_xpo.
Please make sure that your database is started and start Program again.
I contacted the “support” people of the db and they said a sql db cannot be moved / recovered except by back up and restore, which is impossible in this case.
I cannot believe a db product is “unrecoverable” from this.
Did I miss any other sql files like configs or is this just not possible.
I do not want to retype a lot.
There is a program in one of the sub dirs that I think may fix it, but I am not familiar with sql.
irectory of C:\PROGRA~1\MICROS~2\MSSQL\BINN
04/17/2001 11:22 PM 21,056 cmdwrap.exe
12/17/2002 05:23 PM 311,872 sqlagent.EXE
12/17/2002 05:23 PM 156,224 sqlmaint.exe
12/17/2002 05:26 PM 7,520,337 sqlservr.exe
4 File(s) 8,009,489 bytes
0 Dir(s) 399,421,976,576 bytes free
C:\PROGRA~1\MICROS~2\MSSQL\BINN>sqlmaint /p
Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.760
Copyright (C) Microsoft Corporation, 1995 - 1998
USAGE: [-?] | [-S <Server Name>]
[-U <Login ID> [-P <Password>]]
l reports older than given
time period
C:\PROGRA~1\MICROS~2\MSSQL\BINN>sqlmaint -rebldidx
Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.760
Copyright (C) Microsoft Corporation, 1995 - 1998
USAGE: [-?] | [-S <Server Name>]
[-U <Login ID> [-P <Password>]]
-D <Database Name>
[-Rpt <Output File>]
[-To <Operator Name>]
[-CkDB | -CkDBNoIdx]
[-CkAl | -CkAlNoIdx]
[-CkTxtAl]
[-CkCat]
[-UpdSts]
[-RebldIdx <% Free Space>]
[-BkUpDB <Backup Path> | -BkUpLog <Backup Path>]
[-BkUpOnlyIfClean]
[-BkUpMedia DISK [-DelBkUps <time period>] | TAPE]
[-UpdOptiStats <% of Database to Sample>]
[-HtmlRpt <Html File>]
[-VrfyBackup]
[-RmUnusedSpace <Minimum DB in MB> <% of free space to leave>]
[-PlanID <GUID identifying the maintenance plan in 36 character
hex format>]
[-PlanName <Maintenance plan name>]
[-CrBkSubDir] Create a sub-directory (for storing backup files)
for the database(s).
[-UseDefDir] Use the default backup directory.
[-WriteHistory] Write history to msdb.dbo.sysdbmaintplan_history
.
[-DelTxtRpt <time period>] Delete text reports older than given
time period
[-DelHtmlRpt <time period>] Delete html reports older than given
time period
Can any one help me fix this.
5
