Backup Databases SQL

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 HaddadI'm sorry, I don't really understand the question. What do you mean by 'hel
d
back'? Are you asking if there are any DBs that you shouldn't backup?
"Ralph Haddad" wrote:

> 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 exampl
e
> model or msdb?
>
> Thank you,
> Sincerely,
> Ralph Haddad
>|||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
--
Ralph Haddad
"Sean McCown" wrote:
[vbcol=seagreen]
> I'm sorry, I don't really understand the question. What do you mean by 'h
eld
> back'? Are you asking if there are any DBs that you shouldn't backup?
>
> "Ralph Haddad" wrote:
>|||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 othe
r
server.
The only DB you can't actually backup is tempdb. Any other DB should be
backed up... esp the system DBs.
"Ralph Haddad" wrote:
[vbcol=seagreen]
> 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
> --
> Ralph Haddad
>
> "Sean McCown" wrote:
>sql

backup

i am attempting to move a data base to a new system. when trying to backup
the db i get the following error ' incorrect syntax near keyword 'disk' '
from the following
use master
exec sp_addumpdevice 'disk', 'mydb_1',
disk = 'd:\data\backup\mydb_1.dat'
backup database mydbTerry,
This is an example from BooksOnLine for sp_addumpdevice:
USE master
EXEC sp_addumpdevice 'disk', 'mydiskdump', 'c:\dump\dump1.bak'
--
Andrew J. Kelly SQL MVP
"Terry" <cooleyt@.woh.rr.com> wrote in message
news:QA1sd.26481$MG3.10582@.fe2.columbus.rr.com...
>i am attempting to move a data base to a new system. when trying to backup
> the db i get the following error ' incorrect syntax near keyword 'disk' '
> from the following
> use master
> exec sp_addumpdevice 'disk', 'mydb_1',
> disk = 'd:\data\backup\mydb_1.dat'
> backup database mydb
>

backup

i am attempting to move a data base to a new system. when trying to backup
the db i get the following error ' incorrect syntax near keyword 'disk' '
from the following
use master
exec sp_addumpdevice 'disk', 'mydb_1',
disk = 'd:\data\backup\mydb_1.dat'
backup database mydb
Terry,
This is an example from BooksOnLine for sp_addumpdevice:
USE master
EXEC sp_addumpdevice 'disk', 'mydiskdump', 'c:\dump\dump1.bak'
Andrew J. Kelly SQL MVP
"Terry" <cooleyt@.woh.rr.com> wrote in message
news:QA1sd.26481$MG3.10582@.fe2.columbus.rr.com...
>i am attempting to move a data base to a new system. when trying to backup
> the db i get the following error ' incorrect syntax near keyword 'disk' '
> from the following
> use master
> exec sp_addumpdevice 'disk', 'mydb_1',
> disk = 'd:\data\backup\mydb_1.dat'
> backup database mydb
>