Backup Databases SQL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ralph Haddad - 27 Nov 2007 14:12 GMT

Good morning,

I am with some questions concerning Backup of SQL Server 2000 and 2005.

I wonder what the databases should be held back, outside the base of the
system itself, the master, you should hold back up any further, for example
model or msdb?

Thank you,

Sincerely,

Ralph Haddad

Reply to this Message

Sean McCown - 27 Nov 2007 15:20 GMT

I'm sorry, I don't really understand the question. What do you mean by 'held
back'? Are you asking if there are any DBs that you shouldn't backup?

> Good morning,
>
[quoted text clipped - 9 lines]
>
> Ralph Haddad

Reply to this Message

Ralph Haddad - 27 Nov 2007 19:02 GMT

Good Afternoon,

I would like to know what the database should be done Backup? For example,
need make Backup of Database Model? Or database tempdb? master?

Thank you,

Sincerely,

Ralph Haddad

Signature

Ralph Haddad

> I'm sorry, I don't really understand the question. What do you mean by 'held
> back'? Are you asking if there are any DBs that you shouldn't backup?
[quoted text clipped - 12 lines]
> >
> > Ralph Haddad

Reply to this Message

Sean McCown - 27 Nov 2007 19:08 GMT

I understand now. While you don't have to backup model unelss you've done
something special to it, I like to anyway. But you can get it from any other
server.

The only DB you can't actually backup is tempdb. Any other DB should be
backed up... esp the system DBs.

> Good Afternoon,
>
[quoted text clipped - 23 lines]
> > >
> > > Ralph Haddad

Reply to this Message