Showing posts with label regards. Show all posts
Showing posts with label regards. Show all posts

Sunday, March 11, 2012

Backup Database 2000 and restore the data to SQL 7.0

Hi
Is there a way whereby I can restore data set backup from SQL 2000 onto a
SQL 7.0 server? Please advise asap. Thanks a lot
Regards
ChristinaNo. Use some of the export/import methods instead. Like DTS, BCP etc.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:9AB9F395-3F87-4326-9992-5EFAC07E1D49@.microsoft.com...
> Hi
> Is there a way whereby I can restore data set backup from SQL 2000 onto a
> SQL 7.0 server? Please advise asap. Thanks a lot
> Regards
> Christina

Thursday, February 16, 2012

backup

Hi
how to backup a single db on multiple files to split into smaller files .
Regards
AjayBACKUP DATABASE northwind TO
DISK = 'c:\bkp\backup_1.BAK' ,
DISK = 'c:\bkp\backup_2.BAK' ,
DISK = 'c:\bkp\backup_3.BAK'
This will stripe the backup across all these files.
However, all devices must be of the same type ex : disk,
tape etc.
- Vishal