August 15, 2017 at 6:56 am
I am a worker in IT company. One of my tasks is to handle our database in MS SQL Server. But some days ago happened awful thing. Our largest database stopped opening. We checked another databases, they were fine.
August 15, 2017 at 7:21 am
ChloeSanchez - Tuesday, August 15, 2017 6:56 AMI am a worker in IT company. One of my tasks is to handle our database in MS SQL Server. But some days ago happened awful thing. Our largest database stopped opening. We checked another databases, they were fine.
What is your question here exactly? You don't "open" a SQL Server database, so what do you mean by it "stopped opening"? What are the error messages you are receiving. Are the database files located elsewhere to your other databases (I.e. a different SAN, HDD, etc). Was anything different done the day that the database didn't "open"?
We need more information.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 24, 2017 at 9:50 am
If you can’t open or repair .mdf via any method, in such case was created special instrument like repair sql server database
Here are represented the models of sql recovery - https://www.mssqltips.com/sqlservertutorial/2/sql-server-recovery-models/
It is the address of the guide below: https://www.mssqltips.com/sqlservertutorial/112/recovering-a-database-that-is-in-the-restoring-state/
Restore full backup WITH RECOVERY
As mentioned above this option is the default, but you can specify as follows.
RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AdventureWorks.BAK'
WITH RECOVERY
GO
Recover a database that is in the "restoring" state
The following command will take a database that is in the "restoring" state and make it available for end users.
RESTORE DATABASE AdventureWorks WITH RECOVERY
GO
Restore multiple backups using WITH RECOVERY for last backup
The first restore uses the NORECOVERY option so additional restores can be done. The second command restores the transaction log and then brings the database online for end user use.
RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AdventureWorks.BAK'
WITH NORECOVERY
GO
RESTORE LOG AdventureWorks FROM DISK = 'C:\AdventureWorks.TRN'
WITH RECOVERY
GO
August 24, 2017 at 11:21 am
What is the status of the database ? If u are familiar with the explorer window in SSMS , please see if there's anything written to the right of this database on parenthesis.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply