June 15, 2010 at 9:26 am
What is a database dump? is it a database backup? or is it make a BCP of all database tables to txt files with the data inside?
June 15, 2010 at 9:34 am
A database FULL backup. In my last project all DBA's used to call a backup as dump. (may be because they are both sql and oracle dba's). It's just the different terminology used by some people.
SQL DBA.
June 15, 2010 at 9:44 am
Backups used to be called dumps in SQL Server. As mentioned above, it's a backup.
June 15, 2010 at 9:46 am
Ok, thank you.
June 15, 2010 at 8:42 pm
Mainly dump is used for SYBASE where as backup is used for SQL.
dump database [dbname] to 'compress::/<pathname>.bak' ==> for sybase
backup database [dbname]
to disk = 'd:\tempdbackup\dbname.bak'
HTH,
\\K
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂
June 16, 2010 at 6:44 am
SYBASE is a company
SQL is a language
June 16, 2010 at 8:53 am
glen_self (6/16/2010)
SYBASE is a companySQL is a language
Thanks for pointing out ! I should have been more clear !
what I meant by sybase is SYBASE ASE 12.5.4 or 15.0.3
and SQL is SQL server 2005/2008
HTH
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply