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 ««123»»

DataBase Restore Expand / Collapse
Author
Message
Posted Tuesday, December 6, 2005 6:53 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 30, 2014 10:08 PM
Points: 1,038, Visits: 444
Master is the "heart" of your SQL installation   It's hard enough to restore a backup of it - I can only imagine the flaming hoops you would have to jump through to restore additional transaction log backups of it


Post #242438
Posted Wednesday, December 7, 2005 1:54 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 8:11 AM
Points: 3,244, Visits: 529
BOL is the Books on Line. The SQL Server Help files.

-SQLBill



Post #242656
Posted Wednesday, December 7, 2005 2:36 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 9, 2014 4:22 PM
Points: 19, Visits: 22

So, if the Master is the Heart of the database, then, my database is not completly restored, untill I restore it?  Does not body restore the master, or do they just have scripts to recreate the tasks and sercurity login's?

Brian

Post #242668
Posted Wednesday, December 7, 2005 3:06 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 12:53 PM
Points: 3,192, Visits: 2,287
No. The heart is the only organ non-transplantable in this analogy. Restoration of a user database is like receiving a new kidney, again in this analogy.



Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #242678
Posted Thursday, December 8, 2005 4:55 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 30, 2014 10:08 PM
Points: 1,038, Visits: 444

hahaha

Sorry, meant to say it was like the central part of your SQL Server installation.  It itself is essentially another database on SQL, but it must always be there and stores all of your logins, system settings and lists of your other SQL Server databases.. 




Post #242803
Posted Thursday, December 8, 2005 9:15 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 9, 2014 4:22 PM
Points: 19, Visits: 22

Ok, so am i missing something or what?  If the master db contains all my logins and system setting, how do I restore it?  Is there way way to create scripts to recreate my logins, and settings?  Does the master contain the task and jobs, or is that msdb?

Thanks,

Brian

Post #242892
Posted Thursday, December 8, 2005 9:19 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 12:53 PM
Points: 3,192, Visits: 2,287

Here's a reference on SQL 2000 databases no DBA should be without:

http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx

This may answer a great deal of your questions when used in conjunction with BOL.





Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #242896
Posted Thursday, December 8, 2005 9:39 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 9, 2014 4:22 PM
Points: 19, Visits: 22

when i go to that link and open up systbl.chm, nothing is there, "action cancelled"?

Brian

I did start to look through the other files though.

Post #242906
Posted Thursday, December 8, 2005 10:06 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 12:53 PM
Points: 3,192, Visits: 2,287
You should download the file to your local PC then launch it.



Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #242921
Posted Thursday, December 8, 2005 10:13 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 9, 2014 4:22 PM
Points: 19, Visits: 22

I tried that too.

Post #242925
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse