Differential Restore

Win2K3 SQL2K Enterprise Edition
This is my current backup schedule
Sunday FULL
M-Sat Differential
TranLogs Backups every hour
I am trying to restore to a point in time, specifically to the time
right after my last Differentail backup. I am using Ent Manager for
this. I have restored the Full with no recovery and then I select just
the last Differential Backup for restore and I get the message
Cannot apply the backup on device 'd:\abcd\diff' to database 'TEST'
restore database is terminated abnormally
Is there something wrong with my restore process. This is a qa
environment that I am testing this on. I have added a lot of data to
the database and then manual run the diffential job. Now I am trying
to restore to this point but I keep getting this error. Any help would
be appreciated.Please check the backup file you are using.
Thanks
Ajay Rengunthwar|||Ajay, Not sure what you mean exactly. I was able to restore my last
full backup. Both with and without recovery. I am just having trouble
restoring the differentials backup after that.

Differential Restore

Win2K3 SQL2K Enterprise Edition
This is my current backup schedule
Sunday FULL
M-Sat Differential
TranLogs Backups every hour
I am trying to restore to a point in time, specifically to the time
right after my last Differentail backup. I am using Ent Manager for
this. I have restored the Full with no recovery and then I select just
the last Differential Backup for restore and I get the message
Cannot apply the backup on device 'd:\abcd\diff' to database 'TEST'
restore database is terminated abnormally
Is there something wrong with my restore process. This is a qa
environment that I am testing this on. I have added a lot of data to
the database and then manual run the diffential job. Now I am trying
to restore to this point but I keep getting this error. Any help would
be appreciated.Please check the backup file you are using.
Thanks
Ajay Rengunthwar|||Ajay, Not sure what you mean exactly. I was able to restore my last
full backup. Both with and without recovery. I am just having trouble
restoring the differentials backup after that.

Differential data backup sql2k

Hi, all
I am trying to do the data differential databackup daily and full backup
during the weekend.
Log shipping remain the same as usual.
There is anything that I should be aware of before I chnage the backup
method.
It takes too long to have full data backup every night.
Thanks,
Diff backup of the source database does not affect log shipping in any way. So, just make sure you
have thought about disaster recovery, number of backup generations and that you understand the
concept of database, diff and transaction log backups (which are pretty simple).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"mecn" <mecn2002@.yahoo.com> wrote in message news:e0FEv70JGHA.2012@.TK2MSFTNGP14.phx.gbl...
> Hi, all
> I am trying to do the data differential databackup daily and full backup during the weekend.
> Log shipping remain the same as usual.
> There is anything that I should be aware of before I chnage the backup method.
> It takes too long to have full data backup every night.
> Thanks,
>

Differential data backup sql2k

Hi, all
I am trying to do the data differential databackup daily and full backup
during the weekend.
Log shipping remain the same as usual.
There is anything that I should be aware of before I chnage the backup
method.
It takes too long to have full data backup every night.
Thanks,Diff backup of the source database does not affect log shipping in any way.
So, just make sure you
have thought about disaster recovery, number of backup generations and that
you understand the
concept of database, diff and transaction log backups (which are pretty simp
le).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"mecn" <mecn2002@.yahoo.com> wrote in message news:e0FEv70JGHA.2012@.TK2MSFTNGP14.phx.gbl...[v
bcol=seagreen]
> Hi, all
> I am trying to do the data differential databackup daily and full backup d
uring the weekend.
> Log shipping remain the same as usual.
> There is anything that I should be aware of before I chnage the backup met
hod.
> It takes too long to have full data backup every night.
> Thanks,
>[/vbcol]

Differential data backup sql2k

Hi, all
I am trying to do the data differential databackup daily and full backup
during the weekend.
Log shipping remain the same as usual.
There is anything that I should be aware of before I chnage the backup
method.
It takes too long to have full data backup every night.
Thanks,Diff backup of the source database does not affect log shipping in any way. So, just make sure you
have thought about disaster recovery, number of backup generations and that you understand the
concept of database, diff and transaction log backups (which are pretty simple).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"mecn" <mecn2002@.yahoo.com> wrote in message news:e0FEv70JGHA.2012@.TK2MSFTNGP14.phx.gbl...
> Hi, all
> I am trying to do the data differential databackup daily and full backup during the weekend.
> Log shipping remain the same as usual.
> There is anything that I should be aware of before I chnage the backup method.
> It takes too long to have full data backup every night.
> Thanks,
>

Differential backups of sql2k w/BackupExec huge

I am running Sql2k to house my 7GB database. I ran a full backup this
morning and saw amount of data backed up was 7GB. I then decided to try
doing a differential backup to see if it might be a good mid-day solution.
Normally I would do several log backups during the day but because the
application does several unpredictable bulk inserts of external data daily,
my understanding is that this breaks the transaction log sequence and as
such log backup won't work.
Anyway, when I did this differential backup I was very surprised to find
that the 2 users on my system were able to make 2.35GB of changes in an hour
and a half. I know, that isn't necessarily what it means when you get such a
huge diff backup, but what I want to know is why could this be happening and
what options are available to me for mid-day backups. I ran another diff
backup an hour later and 2.4 GB was backed up.
My hunch is that something is causing checkpoints that are trunc'ing the log
such as the db or log auto-growing. To counter these possiblities, I
increased the size of the DB to 10GB and the log file is 500MB just to be
safe.
If I am right and something is causing checkpoints, how can I find out what
it is? I didn't write the app, I am just stuck supporting it.
Mike
<><Whether or not and when checkpoints are occurring does not affect
differential backups... Only data which has changed since the last complete
backup... so those users have changed mucho data...
--
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 community
of SQL Server professionals.
www.sqlpass.org
"Mike Strout" <m i k e s t r o u t @. h o t m a i l . c o m> wrote in message
news:vii9cd3i46t953@.corp.supernews.com...
> I am running Sql2k to house my 7GB database. I ran a full backup this
> morning and saw amount of data backed up was 7GB. I then decided to try
> doing a differential backup to see if it might be a good mid-day solution.
> Normally I would do several log backups during the day but because the
> application does several unpredictable bulk inserts of external data
daily,
> my understanding is that this breaks the transaction log sequence and as
> such log backup won't work.
> Anyway, when I did this differential backup I was very surprised to find
> that the 2 users on my system were able to make 2.35GB of changes in an
hour
> and a half. I know, that isn't necessarily what it means when you get such
a
> huge diff backup, but what I want to know is why could this be happening
and
> what options are available to me for mid-day backups. I ran another diff
> backup an hour later and 2.4 GB was backed up.
> My hunch is that something is causing checkpoints that are trunc'ing the
log
> such as the db or log auto-growing. To counter these possiblities, I
> increased the size of the DB to 10GB and the log file is 500MB just to be
> safe.
> If I am right and something is causing checkpoints, how can I find out
what
> it is? I didn't write the app, I am just stuck supporting it.
> Mike
> <><
>|||Is it possible that index rebuilds or some other bulk operation took place
that would have moved or changed a vast amount of pages in the database?
"Mike Strout" <m i k e s t r o u t @. h o t m a i l . c o m> wrote in message
news:vii9cd3i46t953@.corp.supernews.com...
> I am running Sql2k to house my 7GB database. I ran a full backup this
> morning and saw amount of data backed up was 7GB. I then decided to try
> doing a differential backup to see if it might be a good mid-day solution.
> Normally I would do several log backups during the day but because the
> application does several unpredictable bulk inserts of external data
daily,
> my understanding is that this breaks the transaction log sequence and as
> such log backup won't work.
> Anyway, when I did this differential backup I was very surprised to find
> that the 2 users on my system were able to make 2.35GB of changes in an
hour
> and a half. I know, that isn't necessarily what it means when you get such
a
> huge diff backup, but what I want to know is why could this be happening
and
> what options are available to me for mid-day backups. I ran another diff
> backup an hour later and 2.4 GB was backed up.
> My hunch is that something is causing checkpoints that are trunc'ing the
log
> such as the db or log auto-growing. To counter these possiblities, I
> increased the size of the DB to 10GB and the log file is 500MB just to be
> safe.
> If I am right and something is causing checkpoints, how can I find out
what
> it is? I didn't write the app, I am just stuck supporting it.
> Mike
> <><
>|||Mike Strout (m i k e s t r o u t @. h o t m a i l . c o m) writes:
> Normally I would do several log backups during the day but because the
> application does several unpredictable bulk inserts of external data
> daily, my understanding is that this breaks the transaction log sequence
> and as such log backup won't work.
No, that is not the case. Assuming of course, you are not running in
Simple recovery mode that is. And that you bulk-load operations does
not include BACKUP LOG db WITH NO_LOG.
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Different SQL mail

my config is SQL2000, outlook xp
now i use xp_sendmail to see email from SQL2k
how can i use different mail profiles for different database?
or i can control it at script level?
i have searched google for this and seems it is feasible.
grateful if you could give me some hints.
by the way, i am going to upgrade SQL2000 to SQL2005.
Thanks a lot.
tonyHi
xp_startmail will take a different MAPI profile. You may want to use XPSMTP
instead where the source can be specified http://www.sqldev.net/xp/xpsmtp.htm
John
"Tony WONG" wrote:
> my config is SQL2000, outlook xp
> now i use xp_sendmail to see email from SQL2k
> how can i use different mail profiles for different database?
> or i can control it at script level?
> i have searched google for this and seems it is feasible.
> grateful if you could give me some hints.
> by the way, i am going to upgrade SQL2000 to SQL2005.
> Thanks a lot.
> tony
>
>

Different SQL mail

my config is SQL2000, outlook xp
now i use xp_sendmail to see email from SQL2k
how can i use different mail profiles for different database?
or i can control it at script level?
i have searched google for this and seems it is feasible.
grateful if you could give me some hints.
by the way, i am going to upgrade SQL2000 to SQL2005.
Thanks a lot.
tonyIf you upgrade to 2005, consider using Database Mail instead. See sp_send_dbmail in the 2005
documentation.
As for 2000, I believe that you optionally can use different profiles, although I've never tried it.
See the documentation for xp_startmail.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tony WONG" <x34@.hknet.com> wrote in message news:enyZScRwGHA.1272@.TK2MSFTNGP05.phx.gbl...
> my config is SQL2000, outlook xp
> now i use xp_sendmail to see email from SQL2k
> how can i use different mail profiles for different database?
> or i can control it at script level?
> i have searched google for this and seems it is feasible.
> grateful if you could give me some hints.
> by the way, i am going to upgrade SQL2000 to SQL2005.
> Thanks a lot.
> tony
>

Differences in MS SQL7 and MS SQL2000

I am having difficulty convincing my management to upgrade from our existing MS SQL7 Database to MS SQL2K. I know that SQL2K offers enhanced performance and ease of use but am unable to find any white paper or documentation online that shows me the advantage of SQL2K over our current older version. Is anyone here facing the same problem as me? If any one has any documentation or hyperlinks to point me in the correct place, just post here or drop me an e-mail at chanmunyew@.msn.com to help...any help at all is greatly appreciated!! thanks guys!More links than you can shake a stick at, hope these help:

http://www.microsoft.com/catalog/display.asp?site=10145&subid=22&pg=4#167937

http://www.microsoft.com/sql/evaluation/overview/whatsnew.asp

http://support.microsoft.com/default.aspx?scid=kb;en-us;323049

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part1/c0261.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/whatsnew/wn_whatnew_7im0.asp

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/itcommunity/chats/trans/sql/sq092700.asp|||Thanks!!!!!