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
Showing posts with label regards. Show all posts
Showing posts with label regards. Show all posts
Sunday, March 11, 2012
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
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
Subscribe to:
Posts (Atom)