Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Back up is not getting Expand / Collapse
Author
Message
Posted Friday, August 7, 2009 11:58 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 12, 2012 10:44 PM
Points: 28, Visits: 76
Hi All,

I am unable to take back up off the data base.

when i run querry it shows 3 files are offline, remaining are in online.

Hoq do i get offline files to online.

All these files are full text catalogs.

can any one help me. It's very important. Please.....................!

Thanks,
Suresh.M



Post #767179
Posted Tuesday, August 11, 2009 3:05 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 24, 2013 2:59 AM
Points: 174, Visits: 336
Do you have the last backup?
Post #768985
Posted Wednesday, August 12, 2009 11:33 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 12, 2012 10:44 PM
Points: 28, Visits: 76
when i am taking backup it shows .mdf file is not on-line, can u say how to bring .mdf file into on-line
Post #769527
Posted Wednesday, August 12, 2009 12:37 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 24, 2013 2:59 AM
Points: 174, Visits: 336
I am getting to that but I need to know if you have your last full backup
Post #769577
Posted Wednesday, August 12, 2009 12:57 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 12, 2012 10:44 PM
Points: 28, Visits: 76
I dont have full back up.
That is what my problem. When i want to take a backup it shows u r mdf file is not online.
Post #769596
Posted Thursday, August 13, 2009 12:38 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 24, 2013 2:59 AM
Points: 174, Visits: 336
You will have to backup up at a file level not a full backup. Take a look at books online.

If you were to restore from this then it would mark the same files as offline but you could still work. You have to do commands for the restore so do test this and keep them handy, if you aren't sure how.

If you had backups previously this would not be an issue!
Post #769901
Posted Thursday, August 13, 2009 11:50 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 12, 2012 10:44 PM
Points: 28, Visits: 76
Thanks for u r reply.

But one thing,
i have indevidual files backup like (.mdf file, .log).
And restore the databse based on that mdf and log files.
It working fine. no problem.
But only my concern is i wnat to take full backup and i need to take .mdf file in to online, these two are the important one.
Post #770377
Posted Thursday, August 13, 2009 2:01 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 24, 2013 2:59 AM
Points: 174, Visits: 336
They are offline and the data isn't there. I am not aware of a way to remove them. I always have backups so never encountered the issues.
Post #770479
Posted Tuesday, August 6, 2013 11:28 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 13, 2014 10:06 PM
Points: 16, Visits: 73
Hi ,

The mdf is offline and please confirm ur database is in suspect mode(means database is not responding )
Post #1481465
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse