ADMIN Database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » ADMIN Database

ADMIN Database

Rate Topic

Display Mode

Topic Options

Author

Message

Mani-584606

Posted Tuesday, November 04, 2008 11:40 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 1:28 PM
Points: 535, Visits: 1,797

Hi,

Most dba's use the admin database to keep their backup,restore and maintenance scripts instead of master database. So Iwould like to create a admin database. Could you plz suggest me how this database should be created relating to sysdatabases and user databases.

Thanks

Post #597113

george sibbald

Posted Thursday, November 06, 2008 7:16 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 9:46 AM
Points: 5,269, Visits: 11,204

its certainly a good idea to have a database for your own use to store your code in and any data you might use as a part of your day to day maintenance activities.

create and treat it like any other user database though I would suggest the only maintenance needed on it is backups and simple recovery mode should suffice.

---------------------------------------------------------------------

Post #598100

The_SQL_DBA

Posted Thursday, November 06, 2008 7:51 AM

Right there with Babe

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:23 AM
Points: 794, Visits: 901

Include all the stored procs that you would use in the maintenance jobs and the once with notification too. Simple recovery would be enough and if you don't update it very often then a weekly backup would do.

Use this database as reference for all the jobs that you use for maintenance purpose.

Thanks!!

The_SQL_DBA
MCTS

"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

Post #598152

homebrew01

Posted Thursday, November 06, 2008 8:03 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 8:12 AM
Points: 2,554, Visits: 7,209

I do backups daily ....... better safe than sorry.

Post #598171

Andrew Peterson-472853

Posted Thursday, November 06, 2008 11:49 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, January 16, 2013 7:40 AM
Points: 136, Visits: 259

I agree, set it for simple

The more you are prepared, the less you need it.

Post #598428

homebrew01

Posted Thursday, November 06, 2008 11:52 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 8:12 AM
Points: 2,554, Visits: 7,209

But if you're doing a lot of work in the database, either go FULL with T-log backups like a Production DB, or do more frequent FULLs while the work is going on. Just like any other DB, decide how much work you can offord to lose.

Post #598433

« Prev Topic | Next Topic »

Permissions