| Author |
Topic |
|
regul8
Starting Member
8 Posts |
 Posted - 2004-09-08 : 13:26:27
|
| How do!We have been having problems backing up 4 of our 7 databases at work, this was due to 4 of the 7 saying they were in the middle of a restore (which there not) and so the backup could not get to them.I was told to reboot the server as this would most likely fix the problem, but it hasnt, its made it worse, not the SQL server wont even start, it keeps stopping load up when it hits one of the databases as it thinks its in restore?Is there anyway i can change which databaes are loaded when the SQL manager is started, we are running MS SQL7...Anyone got any ideas, and why are some databases reporting that they are in a restore???Need some help on this!Chris__________________ |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-09-08 : 13:31:49
|
| If it were me, I'd probably call in to MS support for this one. Sounds like you've got a lot at stake here, and a $200 phone call would be worth it.http://www.microsoft.com/services/microsoftservices/supp.mspxMichael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-08 : 13:53:54
|
| Have you tried starting SQL Server from the command line using -c and -f switches? Any errors in the Application Log?Tara |
|
|
|
regul8
Starting Member
8 Posts |
Posted - 2004-09-08 : 14:07:45
|
| tduggan, how do i start the SQL Server from the command line, and what do the -c and -f switches do? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-08 : 14:11:08
|
| Please check SQL Server Books Online for the startup options. The topic is titled "Using Startup Options". To start SQL Server from the command line, you navigate to the appropriate directory, then run sqlservr.exe using whatever switches you need. More information can be found in Books Online.Since you aren't familiar with this, I'd suggest contacting MS as Michael suggested though.Tara |
|
|
|
regul8
Starting Member
8 Posts |
Posted - 2004-09-08 : 14:15:44
|
| Is there no command to run the SQL sever only loading certain databases? |
|
|
|
regul8
Starting Member
8 Posts |
Posted - 2004-09-08 : 15:16:57
|
| How do, been looking on the MS web site and found thishttp://support.microsoft.com/default.aspx?scid=kb;en-us;822852The error listed here is exactly what im getting in the log files:2003-04-18 09:37:38.85 spid5 Starting up database 'model'. 2003-04-18 09:37:39.24 spid5 Bypassing recovery for database 'model' because it is marked IN LOAD. 2003-04-18 09:37:39.65 spid5 Database 'model' cannot be opened. It is in the middle of a restore.Is it risky running the commands listed in the help file? Will they in any way damage the 2 databases that we actually store data in?Chris |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-08 : 15:18:46
|
Is this relevant to your situation:quote:
When you restore the model system database by using the WITH NORECOVERY option, the restore leaves the model database in an unrecovered state. Therefore, the model database can no longer be used as expected.
Of course there's risk involved, but don't you have backups for the databases?Tara |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-09-08 : 15:20:18
|
| If your data /time is worth less than $200 press on. If your data is worth more than $200, CALL MS!!!Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
regul8
Starting Member
8 Posts |
Posted - 2004-09-08 : 15:27:49
|
| I have a backup of the 2 databases we use taken at 16:00 today, so if it all goes tits up i will only lose 1 hours worth of work.As far as i am awhere, there has been no recovery of any databases, but today is the first time i have logged onto the machine, because i was asked why the backups had been failing to backup 4 of the databases. Strange thing is they (4 databases) have only not been backing up since thursday last week, before that they were fine and backed up every night. The 2 databases we use Kovis1 and Kovis2 backup fine every night along with the master database, so it would appear the model database is at fault.Chris |
|
|
|
regul8
Starting Member
8 Posts |
Posted - 2004-09-08 : 15:31:54
|
| If i backup all the files out of the data directory, ill still be able to put it back like it was anyway, wont I? Im taking it that all database information is stored in the 2 files (for each database) that is stored in the data directory...Chris |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-08 : 15:33:31
|
| You can't always recover from the MDF and LDF files though unless you detached the databases or stopped the MSSQLSERVER service prior to copying the files. Your files might be damaged at this point. You really should call MS. We aren't going to be of much help.Tara |
|
|
|
regul8
Starting Member
8 Posts |
Posted - 2004-09-08 : 15:38:00
|
| The server is stopped, it wont start, and you are being of great help, i will call MS if nothing else works, but i have a good backup of the 2 kovis databases and the master database anyway.If the server is not started, from what u have said i should be fine to backup the LDF and MDF files, just in case the solution i posted above doesnt work.At the end of the day, the server is operated by Kodak, so in reality its there issue, but im gonna have a whole team of users unable to work in the morning if I cant get it restarted, which is not going to please the manager.At the end of the day its not my problem, i was told to reboot it by 2 of our technical support but I do want to get it started again...Chris |
|
|
|
|
Urgent SQL query