Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 incremental back up and restore

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-02-13 : 08:51:22
varanasi writes "i need to have portable text incremental back up, need take incremental backup as flat text file and again restore it back to the database from command prompt.

is it possible.


regards
jayaram varanasi"

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-02-13 : 09:12:23
I am not exactly sure what you are asking.

SQL Server does support incremental backups. The format of the backup is not a text file, but you can restore using the command prompt.



-ec
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-02-13 : 11:03:27
If you need to "export" your database as Text Files you can do so using the BCP command line utility

Kristen
Go to Top of Page
   

- Advertisement -