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
Christina
No. 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

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

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

backup database (sql server backup) and files (nt backup)

Hi!
pls. advise, I need to backup some files on hard drive
using NT backup utility and SQL Server database (using sql
server db backups) to one tape. If I backup first some
folders and files with nt backup utility and then sql
server database, the sql server database cannot be
restored ("not a valid sql server backup"). In the other
case (first backed up sql server db then files using nt
backup) I am getting message "inconsistent media, do not
append to this tape"
How can I solve this?
You must use the SQL Server BACKUP command to create a backup file on disk
(or directly to tape) first. Then you can copy this file to tape. You can
not backup the sql files directly with a native NT backup.
Andrew J. Kelly SQL MVP
"Gabriel" <anonymous@.discussions.microsoft.com> wrote in message
news:12d3001c418b3$612a9610$a001280a@.phx.gbl...
> Hi!
> pls. advise, I need to backup some files on hard drive
> using NT backup utility and SQL Server database (using sql
> server db backups) to one tape. If I backup first some
> folders and files with nt backup utility and then sql
> server database, the sql server database cannot be
> restored ("not a valid sql server backup"). In the other
> case (first backed up sql server db then files using nt
> backup) I am getting message "inconsistent media, do not
> append to this tape"
> How can I solve this?

backup database (sql server backup) and files (nt backup)

Hi!
pls. advise, I need to backup some files on hard drive
using NT backup utility and SQL Server database (using sql
server db backups) to one tape. If I backup first some
folders and files with nt backup utility and then sql
server database, the sql server database cannot be
restored ("not a valid sql server backup"). In the other
case (first backed up sql server db then files using nt
backup) I am getting message "inconsistent media, do not
append to this tape"
How can I solve this?You must use the SQL Server BACKUP command to create a backup file on disk
(or directly to tape) first. Then you can copy this file to tape. You can
not backup the sql files directly with a native NT backup.
Andrew J. Kelly SQL MVP
"Gabriel" <anonymous@.discussions.microsoft.com> wrote in message
news:12d3001c418b3$612a9610$a001280a@.phx
.gbl...
> Hi!
> pls. advise, I need to backup some files on hard drive
> using NT backup utility and SQL Server database (using sql
> server db backups) to one tape. If I backup first some
> folders and files with nt backup utility and then sql
> server database, the sql server database cannot be
> restored ("not a valid sql server backup"). In the other
> case (first backed up sql server db then files using nt
> backup) I am getting message "inconsistent media, do not
> append to this tape"
> How can I solve this?

Backup and Restore

HI,
This particular question many of them would have answered, but am not able t
o get the right answer for this, request you to please advise me on this.
Scenario:
Full backup --> 12:00 noon
Differential Backup --> 14:00
Transaction log backup 1--> 14:30
Transaction log backup 2 --> 15:00
If the system crashes at 15:15, To restore the db, i'll apply the fullbackup
, diffrential backup and the last two transaction log backup, which means I'
ll be able to restore the db till 15:00. Now my question is, since the syste
m crashed at 15:15, will I
be able to restore the data for the duration of 15 minutes (15:00 to 15:15)
also?
Thanks in advance
YogYog wrote:

quote:

---

> Scenario:
> Full backup --> 12:00 noon
> Differential Backup --> 14:00
> Transaction log backup 1--> 14:30
> Transaction log backup 2 --> 15:00
> If the system crashes at 15:15, To restore the db, i'll apply the
> fullbackup, diffrential backup and the last two transaction log
> backup, which means I'll be able to restore the db till 15:00. Now my
> question is, since the system crashed at 15:15, will I be able to
> restore the data for the duration of 15 minutes (15:00 to 15:15)
> also?

---

if the backup file is OK after system crash, you just backup it before
restoring anything and then restore as mentioned and then restore that log
backup
hope this is clear enough
regards
Zarko|||Hi Zarko,
Thanks for the response. You mean to say if Transaction log is OK, then I ca
n back it up and then restore the way I have mentioned, right? I agree with
you...
But what if the whole system crashes (no access to the active files) and I h
ad taken the full backup, differential backup and transaction log backup on
different machine, then would I be able to restore the last 15 mins of data?
Am asking this because, fe
w of my friends claim that this is possible and I wanted to know, how...
Thanks again
Yog|||You should place the
1. log away from data
2. data away from master data
3. mirror the log
This sets you up in a situation where the database data can disappear, yet
you can still do a special log backup ( even when the database data is
gone.) The syntax is backup log prod to disk = ... with no_truncate...
This special log backup will have all of the changes since 15:00 in your
scenario....
In a situation when the whole server crashes, your risk of data loss is the
time between log backups, ...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Yog" <anonymous@.discussions.microsoft.com> wrote in message
news:74CC2E51-2951-4186-B638-89BC36414962@.microsoft.com...

quote:

---

> HI,
> This particular question many of them would have answered, but am not able

---

to get the right answer for this, request you to please advise me on this.

quote:

---

> Scenario:
> Full backup --> 12:00 noon
> Differential Backup --> 14:00
> Transaction log backup 1--> 14:30
> Transaction log backup 2 --> 15:00
> If the system crashes at 15:15, To restore the db, i'll apply the

---

fullbackup, diffrential backup and the last two transaction log backup,
which means I'll be able to restore the db till 15:00. Now my question is,
since the system crashed at 15:15, will I be able to restore the data for
the duration of 15 minutes (15:00 to 15:15) also?

quote:

---

> Thanks in advance
> Yog

---

Backup and Restore

HI,
This particular question many of them would have answered, but am not able to get the right answer for this, request you to please advise me on this
Scenario
Full backup --> 12:00 noo
Differential Backup --> 14:00
Transaction log backup 1--> 14:3
Transaction log backup 2 --> 15:0
If the system crashes at 15:15, To restore the db, i'll apply the fullbackup, diffrential backup and the last two transaction log backup, which means I'll be able to restore the db till 15:00. Now my question is, since the system crashed at 15:15, will I be able to restore the data for the duration of 15 minutes (15:00 to 15:15) also?
Thanks in advanc
YogYog wrote:
> Scenario:
> Full backup --> 12:00 noon
> Differential Backup --> 14:00
> Transaction log backup 1--> 14:30
> Transaction log backup 2 --> 15:00
> If the system crashes at 15:15, To restore the db, i'll apply the
> fullbackup, diffrential backup and the last two transaction log
> backup, which means I'll be able to restore the db till 15:00. Now my
> question is, since the system crashed at 15:15, will I be able to
> restore the data for the duration of 15 minutes (15:00 to 15:15)
> also?
if the backup file is OK after system crash, you just backup it before
restoring anything and then restore as mentioned and then restore that log
backup
hope this is clear enough
regards
Zarko|||Hi Zarko,
Thanks for the response. You mean to say if Transaction log is OK, then I can back it up and then restore the way I have mentioned, right? I agree with you..
But what if the whole system crashes (no access to the active files) and I had taken the full backup, differential backup and transaction log backup on different machine, then would I be able to restore the last 15 mins of data? Am asking this because, few of my friends claim that this is possible and I wanted to know, how...
Thanks agai
Yog|||You should place the
1. log away from data
2. data away from master data
3. mirror the log
This sets you up in a situation where the database data can disappear, yet
you can still do a special log backup ( even when the database data is
gone.) The syntax is backup log prod to disk = ... with no_truncate...
This special log backup will have all of the changes since 15:00 in your
scenario....
In a situation when the whole server crashes, your risk of data loss is the
time between log backups, ...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Yog" <anonymous@.discussions.microsoft.com> wrote in message
news:74CC2E51-2951-4186-B638-89BC36414962@.microsoft.com...
> HI,
> This particular question many of them would have answered, but am not able
to get the right answer for this, request you to please advise me on this.
> Scenario:
> Full backup --> 12:00 noon
> Differential Backup --> 14:00
> Transaction log backup 1--> 14:30
> Transaction log backup 2 --> 15:00
> If the system crashes at 15:15, To restore the db, i'll apply the
fullbackup, diffrential backup and the last two transaction log backup,
which means I'll be able to restore the db till 15:00. Now my question is,
since the system crashed at 15:15, will I be able to restore the data for
the duration of 15 minutes (15:00 to 15:15) also?
> Thanks in advance
> Yog