Restore database from differential backup

Is it possible to restore SQLServer database from differential backup with
out need of FULL backup.
Thanks in Advance
krish
No. Diff backup requires that you first restore the most recent database backup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"krish" <krish@.discussions.microsoft.com> wrote in message
news:582A5389-0466-42B1-8EB8-1D5C7DCEC374@.microsoft.com...
> Is it possible to restore SQLServer database from differential backup with
> out need of FULL backup.
> Thanks in Advance
> krish
|||Hi karaszi,
Thanks for a quick reply.
can a database be restored from a full backup of prod server and diff backup
of dev server.
Thanks in Advance
Krish
"Tibor Karaszi" wrote:

> No. Diff backup requires that you first restore the most recent database backup.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "krish" <krish@.discussions.microsoft.com> wrote in message
> news:582A5389-0466-42B1-8EB8-1D5C7DCEC374@.microsoft.com...
>
>
|||hi krish,
differential backup will contain all the activites on the sql server
performed right from the time the last Full backup is taken. You cannot
resote from the differential backup of the dev server on the prod server. The
sequence number will be a mismatch and hence it will not continue. If you
have lost the differential backup of the production due to some reason, you
can try restoring the log backups, if you had taken it'.
If you need more explanation or problem is be defined futher, let me know.
Regards
"krish" wrote:
[vbcol=seagreen]
> Hi karaszi,
> Thanks for a quick reply.
> can a database be restored from a full backup of prod server and diff backup
> of dev server.
> Thanks in Advance
> Krish
> "Tibor Karaszi" wrote:
|||hi mani,
i will explain in clear whats my problem is
i am working with project server and i am looking for
a project plan on a particular date.backup script has removed the fullback
backup files before that date on prod machine.
i have a diff backup from dev machine for that date but no full backup was
there as i have restored with a different db name.
IS there anyway suppose
i have created db name x.my backup script has taken
1st day--diff
2nd day--diff
3rd day--diff
4th day--full
is there anyway can i roll back to 2nd day.
THanks in Advance
krish
"mani" wrote:
[vbcol=seagreen]
> hi krish,
> differential backup will contain all the activites on the sql server
> performed right from the time the last Full backup is taken. You cannot
> resote from the differential backup of the dev server on the prod server. The
> sequence number will be a mismatch and hence it will not continue. If you
> have lost the differential backup of the production due to some reason, you
> can try restoring the log backups, if you had taken it'.
> If you need more explanation or problem is be defined futher, let me know.
> Regards
> "krish" wrote:
|||Your scenario doesn't change the fact that in order to restore from a diff backup, you need to first
restore from that diff backup's most recent database backup. I'm afraid.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"krish" <krish@.discussions.microsoft.com> wrote in message
news:734A87B2-B74C-4644-9EE6-66D160075EEB@.microsoft.com...[vbcol=seagreen]
> hi mani,
> i will explain in clear whats my problem is
> i am working with project server and i am looking for
> a project plan on a particular date.backup script has removed the fullback
> backup files before that date on prod machine.
> i have a diff backup from dev machine for that date but no full backup was
> there as i have restored with a different db name.
> IS there anyway suppose
> i have created db name x.my backup script has taken
> 1st day--diff
> 2nd day--diff
> 3rd day--diff
> 4th day--full
> is there anyway can i roll back to 2nd day.
> THanks in Advance
> krish
> "mani" wrote:
sql

Restore database from differential backup

Is it possible to restore SQLServer database from differential backup with
out need of FULL backup.
Thanks in Advance
krishNo. Diff backup requires that you first restore the most recent database bac
kup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"krish" <krish@.discussions.microsoft.com> wrote in message
news:582A5389-0466-42B1-8EB8-1D5C7DCEC374@.microsoft.com...
> Is it possible to restore SQLServer database from differential backup with
> out need of FULL backup.
> Thanks in Advance
> krish|||Hi karaszi,
Thanks for a quick reply.
can a database be restored from a full backup of prod server and diff backup
of dev server.
Thanks in Advance
Krish
"Tibor Karaszi" wrote:

> No. Diff backup requires that you first restore the most recent database b
ackup.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "krish" <krish@.discussions.microsoft.com> wrote in message
> news:582A5389-0466-42B1-8EB8-1D5C7DCEC374@.microsoft.com...
>
>|||hi krish,
differential backup will contain all the activites on the sql server
performed right from the time the last Full backup is taken. You cannot
resote from the differential backup of the dev server on the prod server. Th
e
sequence number will be a mismatch and hence it will not continue. If you
have lost the differential backup of the production due to some reason, you
can try restoring the log backups, if you had taken it'.
If you need more explanation or problem is be defined futher, let me know.
Regards
"krish" wrote:
[vbcol=seagreen]
> Hi karaszi,
> Thanks for a quick reply.
> can a database be restored from a full backup of prod server and diff back
up
> of dev server.
> Thanks in Advance
> Krish
> "Tibor Karaszi" wrote:
>|||hi mani,
i will explain in clear whats my problem is
i am working with project server and i am looking for
a project plan on a particular date.backup script has removed the fullback
backup files before that date on prod machine.
i have a diff backup from dev machine for that date but no full backup was
there as i have restored with a different db name.
IS there anyway suppose
i have created db name x.my backup script has taken
1st day--diff
2nd day--diff
3rd day--diff
4th day--full
is there anyway can i roll back to 2nd day.
THanks in Advance
krish
"mani" wrote:
[vbcol=seagreen]
> hi krish,
> differential backup will contain all the activites on the sql server
> performed right from the time the last Full backup is taken. You cannot
> resote from the differential backup of the dev server on the prod server.
The
> sequence number will be a mismatch and hence it will not continue. If you
> have lost the differential backup of the production due to some reason, yo
u
> can try restoring the log backups, if you had taken it'.
> If you need more explanation or problem is be defined futher, let me know.
> Regards
> "krish" wrote:
>|||Your scenario doesn't change the fact that in order to restore from a diff b
ackup, you need to first
restore from that diff backup's most recent database backup. I'm afraid.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"krish" <krish@.discussions.microsoft.com> wrote in message
news:734A87B2-B74C-4644-9EE6-66D160075EEB@.microsoft.com...[vbcol=seagreen]
> hi mani,
> i will explain in clear whats my problem is
> i am working with project server and i am looking for
> a project plan on a particular date.backup script has removed the fullback
> backup files before that date on prod machine.
> i have a diff backup from dev machine for that date but no full backup w
as
> there as i have restored with a different db name.
> IS there anyway suppose
> i have created db name x.my backup script has taken
> 1st day--diff
> 2nd day--diff
> 3rd day--diff
> 4th day--full
> is there anyway can i roll back to 2nd day.
> THanks in Advance
> krish
> "mani" wrote:
>

Restore database from differential backup

Is it possible to restore SQLServer database from differential backup with
out need of FULL backup.
Thanks in Advance
krishNo. Diff backup requires that you first restore the most recent database backup.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"krish" <krish@.discussions.microsoft.com> wrote in message
news:582A5389-0466-42B1-8EB8-1D5C7DCEC374@.microsoft.com...
> Is it possible to restore SQLServer database from differential backup with
> out need of FULL backup.
> Thanks in Advance
> krish|||Hi karaszi,
Thanks for a quick reply.
can a database be restored from a full backup of prod server and diff backup
of dev server.
Thanks in Advance
Krish
"Tibor Karaszi" wrote:
> No. Diff backup requires that you first restore the most recent database backup.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "krish" <krish@.discussions.microsoft.com> wrote in message
> news:582A5389-0466-42B1-8EB8-1D5C7DCEC374@.microsoft.com...
> > Is it possible to restore SQLServer database from differential backup with
> > out need of FULL backup.
> >
> > Thanks in Advance
> > krish
>
>|||hi krish,
differential backup will contain all the activites on the sql server
performed right from the time the last Full backup is taken. You cannot
resote from the differential backup of the dev server on the prod server. The
sequence number will be a mismatch and hence it will not continue. If you
have lost the differential backup of the production due to some reason, you
can try restoring the log backups, if you had taken it'.
If you need more explanation or problem is be defined futher, let me know.
Regards
"krish" wrote:
> Hi karaszi,
> Thanks for a quick reply.
> can a database be restored from a full backup of prod server and diff backup
> of dev server.
> Thanks in Advance
> Krish
> "Tibor Karaszi" wrote:
> > No. Diff backup requires that you first restore the most recent database backup.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "krish" <krish@.discussions.microsoft.com> wrote in message
> > news:582A5389-0466-42B1-8EB8-1D5C7DCEC374@.microsoft.com...
> > > Is it possible to restore SQLServer database from differential backup with
> > > out need of FULL backup.
> > >
> > > Thanks in Advance
> > > krish
> >
> >
> >|||hi mani,
i will explain in clear whats my problem is
i am working with project server and i am looking for
a project plan on a particular date.backup script has removed the fullback
backup files before that date on prod machine.
i have a diff backup from dev machine for that date but no full backup was
there as i have restored with a different db name.
IS there anyway suppose
i have created db name x.my backup script has taken
1st day--diff
2nd day--diff
3rd day--diff
4th day--full
is there anyway can i roll back to 2nd day.
THanks in Advance
krish
"mani" wrote:
> hi krish,
> differential backup will contain all the activites on the sql server
> performed right from the time the last Full backup is taken. You cannot
> resote from the differential backup of the dev server on the prod server. The
> sequence number will be a mismatch and hence it will not continue. If you
> have lost the differential backup of the production due to some reason, you
> can try restoring the log backups, if you had taken it'.
> If you need more explanation or problem is be defined futher, let me know.
> Regards
> "krish" wrote:
> > Hi karaszi,
> > Thanks for a quick reply.
> > can a database be restored from a full backup of prod server and diff backup
> > of dev server.
> >
> > Thanks in Advance
> > Krish
> >
> > "Tibor Karaszi" wrote:
> >
> > > No. Diff backup requires that you first restore the most recent database backup.
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > http://www.karaszi.com/sqlserver/default.asp
> > > http://www.solidqualitylearning.com/
> > >
> > >
> > > "krish" <krish@.discussions.microsoft.com> wrote in message
> > > news:582A5389-0466-42B1-8EB8-1D5C7DCEC374@.microsoft.com...
> > > > Is it possible to restore SQLServer database from differential backup with
> > > > out need of FULL backup.
> > > >
> > > > Thanks in Advance
> > > > krish
> > >
> > >
> > >|||Your scenario doesn't change the fact that in order to restore from a diff backup, you need to first
restore from that diff backup's most recent database backup. I'm afraid.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"krish" <krish@.discussions.microsoft.com> wrote in message
news:734A87B2-B74C-4644-9EE6-66D160075EEB@.microsoft.com...
> hi mani,
> i will explain in clear whats my problem is
> i am working with project server and i am looking for
> a project plan on a particular date.backup script has removed the fullback
> backup files before that date on prod machine.
> i have a diff backup from dev machine for that date but no full backup was
> there as i have restored with a different db name.
> IS there anyway suppose
> i have created db name x.my backup script has taken
> 1st day--diff
> 2nd day--diff
> 3rd day--diff
> 4th day--full
> is there anyway can i roll back to 2nd day.
> THanks in Advance
> krish
> "mani" wrote:
> > hi krish,
> >
> > differential backup will contain all the activites on the sql server
> > performed right from the time the last Full backup is taken. You cannot
> > resote from the differential backup of the dev server on the prod server. The
> > sequence number will be a mismatch and hence it will not continue. If you
> > have lost the differential backup of the production due to some reason, you
> > can try restoring the log backups, if you had taken it'.
> >
> > If you need more explanation or problem is be defined futher, let me know.
> >
> > Regards
> >
> > "krish" wrote:
> >
> > > Hi karaszi,
> > > Thanks for a quick reply.
> > > can a database be restored from a full backup of prod server and diff backup
> > > of dev server.
> > >
> > > Thanks in Advance
> > > Krish
> > >
> > > "Tibor Karaszi" wrote:
> > >
> > > > No. Diff backup requires that you first restore the most recent database backup.
> > > >
> > > > --
> > > > Tibor Karaszi, SQL Server MVP
> > > > http://www.karaszi.com/sqlserver/default.asp
> > > > http://www.solidqualitylearning.com/
> > > >
> > > >
> > > > "krish" <krish@.discussions.microsoft.com> wrote in message
> > > > news:582A5389-0466-42B1-8EB8-1D5C7DCEC374@.microsoft.com...
> > > > > Is it possible to restore SQLServer database from differential backup with
> > > > > out need of FULL backup.
> > > > >
> > > > > Thanks in Advance
> > > > > krish
> > > >
> > > >
> > > >

Restore backup differential on a differente server

I got TWO sqlserver .
The first is the main server , every one hour I make a differential
backup of a Db ( TestDB ) with a Job that save de file .BAK in a
folder of the second server .
Now I need to create a Job that restore the db on the second server
How can I do this ? I'm only able to restore the full backup not
differential backup :-(
please help me
thanksHave you looked at this?
http://msdn2.microsoft.com/en-us/library/ms175510.aspx
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
<emanuele.pasinetti@.gmail.com> wrote in message
news:1163436938.589340.226360@.f16g2000cwb.googlegroups.com...
>I got TWO sqlserver .
> The first is the main server , every one hour I make a differential
> backup of a Db ( TestDB ) with a Job that save de file .BAK in a
> folder of the second server .
> Now I need to create a Job that restore the db on the second server
> How can I do this ? I'm only able to restore the full backup not
> differential backup :-(
> please help me
> thanks
>|||I'm working with SqlServer 2000 , I think this is about 2005, true ?
Roger Wolter[MSFT] ha scritto:
[vbcol=seagreen]
> Have you looked at this?
> http://msdn2.microsoft.com/en-us/library/ms175510.aspx
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> <emanuele.pasinetti@.gmail.com> wrote in message
> news:1163436938.589340.226360@.f16g2000cwb.googlegroups.com...|||All you need to do is to schedule a job in which you have a job step executi
ng the RESTORE DATABASE
command.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Pasi" <emanuele.pasinetti@.gmail.com> wrote in message
news:1163449604.753979.234130@.h48g2000cwc.googlegroups.com...
> I'm working with SqlServer 2000 , I think this is about 2005, true ?
> Roger Wolter[MSFT] ha scritto:
>
>|||Sorry, I must have missed where you said your were using SQL 2000
http://msdn.microsoft.com/library/d... />
t_7tv7.asp
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Pasi" <emanuele.pasinetti@.gmail.com> wrote in message
news:1163449604.753979.234130@.h48g2000cwc.googlegroups.com...
> I'm working with SqlServer 2000 , I think this is about 2005, true ?
> Roger Wolter[MSFT] ha scritto:
>
>

Restore backup differential on a differente server

I got TWO sqlserver .
The first is the main server , every one hour I make a differential
backup of a Db ( TestDB ) with a Job that save de file .BAK in a
folder of the second server .
Now I need to create a Job that restore the db on the second server
How can I do this ? I'm only able to restore the full backup not
differential backup :-(
please help me
thanks
Have you looked at this?
http://msdn2.microsoft.com/en-us/library/ms175510.aspx
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
<emanuele.pasinetti@.gmail.com> wrote in message
news:1163436938.589340.226360@.f16g2000cwb.googlegr oups.com...
>I got TWO sqlserver .
> The first is the main server , every one hour I make a differential
> backup of a Db ( TestDB ) with a Job that save de file .BAK in a
> folder of the second server .
> Now I need to create a Job that restore the db on the second server
> How can I do this ? I'm only able to restore the full backup not
> differential backup :-(
> please help me
> thanks
>
|||I'm working with SqlServer 2000 , I think this is about 2005, true ?
Roger Wolter[MSFT] ha scritto:
[vbcol=seagreen]
> Have you looked at this?
> http://msdn2.microsoft.com/en-us/library/ms175510.aspx
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> <emanuele.pasinetti@.gmail.com> wrote in message
> news:1163436938.589340.226360@.f16g2000cwb.googlegr oups.com...
|||Sorry, I must have missed where you said your were using SQL 2000
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_7tv7.asp
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Pasi" <emanuele.pasinetti@.gmail.com> wrote in message
news:1163449604.753979.234130@.h48g2000cwc.googlegr oups.com...
> I'm working with SqlServer 2000 , I think this is about 2005, true ?
> Roger Wolter[MSFT] ha scritto:
>

Restore backup differential on a differente server

I got TWO sqlserver .
The first is the main server , every one hour I make a differential
backup of a Db ( TestDB ) with a Job that save de file .BAK in a
folder of the second server .
Now I need to create a Job that restore the db on the second server
How can I do this ? I'm only able to restore the full backup not
differential backup :-(
please help me
thanksHave you looked at this?
http://msdn2.microsoft.com/en-us/library/ms175510.aspx
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
<emanuele.pasinetti@.gmail.com> wrote in message
news:1163436938.589340.226360@.f16g2000cwb.googlegroups.com...
>I got TWO sqlserver .
> The first is the main server , every one hour I make a differential
> backup of a Db ( TestDB ) with a Job that save de file .BAK in a
> folder of the second server .
> Now I need to create a Job that restore the db on the second server
> How can I do this ? I'm only able to restore the full backup not
> differential backup :-(
> please help me
> thanks
>|||I'm working with SqlServer 2000 , I think this is about 2005, true ?
Roger Wolter[MSFT] ha scritto:
> Have you looked at this?
> http://msdn2.microsoft.com/en-us/library/ms175510.aspx
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> <emanuele.pasinetti@.gmail.com> wrote in message
> news:1163436938.589340.226360@.f16g2000cwb.googlegroups.com...
> >I got TWO sqlserver .
> > The first is the main server , every one hour I make a differential
> > backup of a Db ( TestDB ) with a Job that save de file .BAK in a
> > folder of the second server .
> >
> > Now I need to create a Job that restore the db on the second server
> > How can I do this ? I'm only able to restore the full backup not
> > differential backup :-(
> > please help me
> > thanks
> >|||All you need to do is to schedule a job in which you have a job step executing the RESTORE DATABASE
command.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Pasi" <emanuele.pasinetti@.gmail.com> wrote in message
news:1163449604.753979.234130@.h48g2000cwc.googlegroups.com...
> I'm working with SqlServer 2000 , I think this is about 2005, true ?
> Roger Wolter[MSFT] ha scritto:
>> Have you looked at this?
>> http://msdn2.microsoft.com/en-us/library/ms175510.aspx
>>
>> --
>> This posting is provided "AS IS" with no warranties, and confers no rights.
>> Use of included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm
>> <emanuele.pasinetti@.gmail.com> wrote in message
>> news:1163436938.589340.226360@.f16g2000cwb.googlegroups.com...
>> >I got TWO sqlserver .
>> > The first is the main server , every one hour I make a differential
>> > backup of a Db ( TestDB ) with a Job that save de file .BAK in a
>> > folder of the second server .
>> >
>> > Now I need to create a Job that restore the db on the second server
>> > How can I do this ? I'm only able to restore the full backup not
>> > differential backup :-(
>> > please help me
>> > thanks
>> >
>|||Sorry, I must have missed where you said your were using SQL 2000
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_7tv7.asp
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Pasi" <emanuele.pasinetti@.gmail.com> wrote in message
news:1163449604.753979.234130@.h48g2000cwc.googlegroups.com...
> I'm working with SqlServer 2000 , I think this is about 2005, true ?
> Roger Wolter[MSFT] ha scritto:
>> Have you looked at this?
>> http://msdn2.microsoft.com/en-us/library/ms175510.aspx
>>
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm
>> <emanuele.pasinetti@.gmail.com> wrote in message
>> news:1163436938.589340.226360@.f16g2000cwb.googlegroups.com...
>> >I got TWO sqlserver .
>> > The first is the main server , every one hour I make a differential
>> > backup of a Db ( TestDB ) with a Job that save de file .BAK in a
>> > folder of the second server .
>> >
>> > Now I need to create a Job that restore the db on the second server
>> > How can I do this ? I'm only able to restore the full backup not
>> > differential backup :-(
>> > please help me
>> > thanks
>> >
>

restore a differential backup into a database with a different name

I have a full back-up + differential backup of a database that I need to
restore onto another server. After I copied the backup onto the other
server, I selected restore from device and from its contents, I can see both
the full backup + differential backup. However, I am not able to restore
differential backup by checking the checkbox next to it. Any idea what I am
doing wrong? I am able to restore the full + differential backup into the
original db where the backups are made from.
Thanks in advance
Perhaps some problem in the GUI (hard to tell without any error messages)?
I suggest you use Query Analyzer and the RESTORE command. You might want to investigate the backup
file(s) first using RESTORE and the HEADERONLY and FILELISTONLY options.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"CW" <CW@.nospam.com> wrote in message news:O2AeipQNFHA.3076@.TK2MSFTNGP14.phx.gbl...
>I have a full back-up + differential backup of a database that I need to restore onto another
>server. After I copied the backup onto the other server, I selected restore from device and from
>its contents, I can see both the full backup + differential backup. However, I am not able to
>restore differential backup by checking the checkbox next to it. Any idea what I am doing wrong? I
>am able to restore the full + differential backup into the original db where the backups are made
>from.
> Thanks in advance
>

restore a differential backup into a database with a different name

I have a full back-up + differential backup of a database that I need to
restore onto another server. After I copied the backup onto the other
server, I selected restore from device and from its contents, I can see both
the full backup + differential backup. However, I am not able to restore
differential backup by checking the checkbox next to it. Any idea what I am
doing wrong? I am able to restore the full + differential backup into the
original db where the backups are made from.
Thanks in advancePerhaps some problem in the GUI (hard to tell without any error messages)?
I suggest you use Query Analyzer and the RESTORE command. You might want to investigate the backup
file(s) first using RESTORE and the HEADERONLY and FILELISTONLY options.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"CW" <CW@.nospam.com> wrote in message news:O2AeipQNFHA.3076@.TK2MSFTNGP14.phx.gbl...
>I have a full back-up + differential backup of a database that I need to restore onto another
>server. After I copied the backup onto the other server, I selected restore from device and from
>its contents, I can see both the full backup + differential backup. However, I am not able to
>restore differential backup by checking the checkbox next to it. Any idea what I am doing wrong? I
>am able to restore the full + differential backup into the original db where the backups are made
>from.
> Thanks in advance
>

restore a differential backup into a database with a different name

I have a full back-up + differential backup of a database that I need to
restore onto another server. After I copied the backup onto the other
server, I selected restore from device and from its contents, I can see both
the full backup + differential backup. However, I am not able to restore
differential backup by checking the checkbox next to it. Any idea what I am
doing wrong? I am able to restore the full + differential backup into the
original db where the backups are made from.
Thanks in advancePerhaps some problem in the GUI (hard to tell without any error messages)?
I suggest you use Query Analyzer and the RESTORE command. You might want to
investigate the backup
file(s) first using RESTORE and the HEADERONLY and FILELISTONLY options.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"CW" <CW@.nospam.com> wrote in message news:O2AeipQNFHA.3076@.TK2MSFTNGP14.phx.gbl...agreen">
>I have a full back-up + differential backup of a database that I need to re
store onto another
>server. After I copied the backup onto the other server, I selected restore
from device and from
>its contents, I can see both the full backup + differential backup. However
, I am not able to
>restore differential backup by checking the checkbox next to it. Any idea w
hat I am doing wrong? I
>am able to restore the full + differential backup into the original db wher
e the backups are made
>from.
> Thanks in advance
>

Restore a Database with Differential

Hello All,

I'm new to this forum after read a few question error it given me little bit more understanding. But here's my problem I was create a database implement some tables than make a 'Full Backup' and input information on the table before make a 'Differential Backup'. I don't want restore a full database and just want to recovery specific table were deleted or removed. Please help........

Message show error:

Restore failed for Server 'SALES18'. (Microsoft.SqlServer.Smo)

Additional information:

System.Data.SqlClient.SqlError: The log or differential backup cannot be restored because no files are ready to rollforward.

Thank you very much.

A differential backup, though only containing changed data pages since the last full database backup, can only be restored in conjuntion with a full backup similar to using log backups. You don't have the ability to restore only single tables or objects, but you can restore at the database, filegroup, file, and page level. You can also restore up to a particular point in time from any of the backups (assuming you've restored the required preceding full, diff, logs).

Possibly the best solution for you in this case would be to restore the database using a different database name, then moving only the data you want into your existing database? Not sure if that's exactly what you're trying to achieve though...

HTH

|||

Good Morning

Chad,

Thank you very much for your response.

Your answers it helping me understand the problem that generated by Sql Server 2005. I'm able to create a full, differential, and trans log backup and restore database to point in time but I have not done on filegroup and file backup/restore.

Questions: How do I determine the proper steps to do a restore data from disk only? Or do you know a particular website talk about 'software' do backup on tape?

My goal is to create a Maintenance Plan, Full,Diff, & TransLog backup and restore data. I'm anticipating to help the database team to do a performance backup & restore data.

Thank you against.

Ryan,

|||

Hey Ryan. Sorry, but I guess I don't really understand the question. Are you asking how to determine the proper steps to simply perform a restore of available backups that have been taken, or are you asking for differences between native Sql backups vs. 3rd party backups (like LiteSpeed for example) vs. Hardware based solutions (i.e. Snapclones, etc.)?

|||

Hi Chad,

This is a totally new for me to step in the SQL Server environment. Be honest with you try learn at much that I can to attached the skill apply to the company. If I like doing sql queries, what are the proper steps for me to do practice? Also, I'm thinking about to certify SQL Server but not sure which version is suitable.

Right now, my current tasks it to find out multiple SQL Server free disk space or been used. Notice there is a script .vbs to track the drive. Do you know any good site to do some research on?

Thank you

ryan--

|||

I am also facing this problem and getting this error message I don’t know why SQL2k is producing this error. I have just restored a backup for 30 March after that ideally restore window should show me the differential backups that are taken as base of 30 march but unable to see and when i try to restore the backup of 31 march by mentioning the device contain differential backup the I got this error

"System.Data.SqlClient.SqlError: The log or differential backup cannot be restored because no files are ready to roll forward. (Microsoft.SqlServer."

any one idea..

We r using SQL Server 2005 with SP2 (64 bit)and window service pack 2 also. A ntbackup utility is schedule to take backup every night 21:55 while differential backup is taken on 20:35

Many thanks in advance

|||

In order to restore a differential backup you must have a database into which the full backup has been restored using the WITH NORECOVERY option. This prevents it from tidying up the database and making it available for use. If restoring using Management Studio then select the second Recovery state option (Leave the database non-operational).

You use NORECOVERY at every step of restoration of backups until the last one. The SQL Server BOL shows it in example B here: http://msdn2.microsoft.com/en-us/library/ms186858.aspx#restoring_full_n_differential_db_backups.

|||

SQL Server Writer service When running, Database Engine locks and has exclusive access to the data files and also put a entry in "backup" table of MSDB databse which update the First and last LSN number against each database instance on MS SQL server.So the differentails backup becomes invalid becuase it seeks its full backup thru LSN number.

SO you get this messages so SQL Server Writer service should shutdown during wohle day so that it could not become invalid ur differential backup.

example :

your first backup thru SQL backup utility

DatabaseName First LSN LastLSN

AAA_Database 000012345 000012346

Differentail Backup off AAA_database

DatabaseName First LSN LastLSN

AAA_Database 000012347 000012348

your NTbackup utulity is running and SP2 of SQL and windows server has installed

DatabaseName First LSN LastLSN

AAA_Database 000012349 000012340

when urestore Differenail backup then u got the message deescribed in this thread. Because sql server detects that a latest full backup has done.

Solution is only shutdown ur SQL Writer Service.

Restore a Database with Differential

Hello All,

I'm new to this forum after read a few question error it given me little bit more understanding. But here's my problem I was create a database implement some tables than make a 'Full Backup' and input information on the table before make a 'Differential Backup'. I don't want restore a full database and just want to recovery specific table were deleted or removed. Please help........

Message show error:

Restore failed for Server 'SALES18'. (Microsoft.SqlServer.Smo)

Additional information:

System.Data.SqlClient.SqlError: The log or differential backup cannot be restored because no files are ready to rollforward.

Thank you very much.

A differential backup, though only containing changed data pages since the last full database backup, can only be restored in conjuntion with a full backup similar to using log backups. You don't have the ability to restore only single tables or objects, but you can restore at the database, filegroup, file, and page level. You can also restore up to a particular point in time from any of the backups (assuming you've restored the required preceding full, diff, logs).

Possibly the best solution for you in this case would be to restore the database using a different database name, then moving only the data you want into your existing database? Not sure if that's exactly what you're trying to achieve though...

HTH

|||

Good Morning

Chad,

Thank you very much for your response.

Your answers it helping me understand the problem that generated by Sql Server 2005. I'm able to create a full, differential, and trans log backup and restore database to point in time but I have not done on filegroup and file backup/restore.

Questions: How do I determine the proper steps to do a restore data from disk only? Or do you know a particular website talk about 'software' do backup on tape?

My goal is to create a Maintenance Plan, Full,Diff, & TransLog backup and restore data. I'm anticipating to help the database team to do a performance backup & restore data.

Thank you against.

Ryan,

|||

Hey Ryan. Sorry, but I guess I don't really understand the question. Are you asking how to determine the proper steps to simply perform a restore of available backups that have been taken, or are you asking for differences between native Sql backups vs. 3rd party backups (like LiteSpeed for example) vs. Hardware based solutions (i.e. Snapclones, etc.)?

|||

Hi Chad,

This is a totally new for me to step in the SQL Server environment. Be honest with you try learn at much that I can to attached the skill apply to the company. If I like doing sql queries, what are the proper steps for me to do practice? Also, I'm thinking about to certify SQL Server but not sure which version is suitable.

Right now, my current tasks it to find out multiple SQL Server free disk space or been used. Notice there is a script .vbs to track the drive. Do you know any good site to do some research on?

Thank you

ryan--

|||

I am also facing this problem and getting this error message I don’t know why SQL2k is producing this error. I have just restored a backup for 30 March after that ideally restore window should show me the differential backups that are taken as base of 30 march but unable to see and when i try to restore the backup of 31 march by mentioning the device contain differential backup the I got this error

"System.Data.SqlClient.SqlError: The log or differential backup cannot be restored because no files are ready to roll forward. (Microsoft.SqlServer."

any one idea..

We r using SQL Server 2005 with SP2 (64 bit)and window service pack 2 also. A ntbackup utility is schedule to take backup every night 21:55 while differential backup is taken on 20:35

Many thanks in advance

|||

In order to restore a differential backup you must have a database into which the full backup has been restored using the WITH NORECOVERY option. This prevents it from tidying up the database and making it available for use. If restoring using Management Studio then select the second Recovery state option (Leave the database non-operational).

You use NORECOVERY at every step of restoration of backups until the last one. The SQL Server BOL shows it in example B here: http://msdn2.microsoft.com/en-us/library/ms186858.aspx#restoring_full_n_differential_db_backups.

|||

SQL Server Writer service When running, Database Engine locks and has exclusive access to the data files and also put a entry in "backup" table of MSDB databse which update the First and last LSN number against each database instance on MS SQL server.So the differentails backup becomes invalid becuase it seeks its full backup thru LSN number.

SO you get this messages so SQL Server Writer service should shutdown during wohle day so that it could not become invalid ur differential backup.

example :

your first backup thru SQL backup utility

DatabaseName First LSN LastLSN

AAA_Database 000012345 000012346

Differentail Backup off AAA_database

DatabaseName First LSN LastLSN

AAA_Database 000012347 000012348

your NTbackup utulity is running and SP2 of SQL and windows server has installed

DatabaseName First LSN LastLSN

AAA_Database 000012349 000012340

when urestore Differenail backup then u got the message deescribed in this thread. Because sql server detects that a latest full backup has done.

Solution is only shutdown ur SQL Writer Service.

Restore a Database with Differential

Hello All,

I'm new to this forum after read a few question error it given me little bit more understanding. But here's my problem I was create a database implement some tables than make a 'Full Backup' and input information on the table before make a 'Differential Backup'. I don't want restore a full database and just want to recovery specific table were deleted or removed. Please help........

Message show error:

Restore failed for Server 'SALES18'. (Microsoft.SqlServer.Smo)

Additional information:

System.Data.SqlClient.SqlError: The log or differential backup cannot be restored because no files are ready to rollforward.

Thank you very much.

A differential backup, though only containing changed data pages since the last full database backup, can only be restored in conjuntion with a full backup similar to using log backups. You don't have the ability to restore only single tables or objects, but you can restore at the database, filegroup, file, and page level. You can also restore up to a particular point in time from any of the backups (assuming you've restored the required preceding full, diff, logs).

Possibly the best solution for you in this case would be to restore the database using a different database name, then moving only the data you want into your existing database? Not sure if that's exactly what you're trying to achieve though...

HTH

|||

Good Morning

Chad,

Thank you very much for your response.

Your answers it helping me understand the problem that generated by Sql Server 2005. I'm able to create a full, differential, and trans log backup and restore database to point in time but I have not done on filegroup and file backup/restore.

Questions: How do I determine the proper steps to do a restore data from disk only? Or do you know a particular website talk about 'software' do backup on tape?

My goal is to create a Maintenance Plan, Full,Diff, & TransLog backup and restore data. I'm anticipating to help the database team to do a performance backup & restore data.

Thank you against.

Ryan,

|||

Hey Ryan. Sorry, but I guess I don't really understand the question. Are you asking how to determine the proper steps to simply perform a restore of available backups that have been taken, or are you asking for differences between native Sql backups vs. 3rd party backups (like LiteSpeed for example) vs. Hardware based solutions (i.e. Snapclones, etc.)?

|||

Hi Chad,

This is a totally new for me to step in the SQL Server environment. Be honest with you try learn at much that I can to attached the skill apply to the company. If I like doing sql queries, what are the proper steps for me to do practice? Also, I'm thinking about to certify SQL Server but not sure which version is suitable.

Right now, my current tasks it to find out multiple SQL Server free disk space or been used. Notice there is a script .vbs to track the drive. Do you know any good site to do some research on?

Thank you

ryan--

|||

I am also facing this problem and getting this error message I don’t know why SQL2k is producing this error. I have just restored a backup for 30 March after that ideally restore window should show me the differential backups that are taken as base of 30 march but unable to see and when i try to restore the backup of 31 march by mentioning the device contain differential backup the I got this error

"System.Data.SqlClient.SqlError: The log or differential backup cannot be restored because no files are ready to roll forward. (Microsoft.SqlServer."

any one idea..

We r using SQL Server 2005 with SP2 (64 bit)and window service pack 2 also. A ntbackup utility is schedule to take backup every night 21:55 while differential backup is taken on 20:35

Many thanks in advance

|||

In order to restore a differential backup you must have a database into which the full backup has been restored using the WITH NORECOVERY option. This prevents it from tidying up the database and making it available for use. If restoring using Management Studio then select the second Recovery state option (Leave the database non-operational).

You use NORECOVERY at every step of restoration of backups until the last one. The SQL Server BOL shows it in example B here: http://msdn2.microsoft.com/en-us/library/ms186858.aspx#restoring_full_n_differential_db_backups.

|||

SQL Server Writer service When running, Database Engine locks and has exclusive access to the data files and also put a entry in "backup" table of MSDB databse which update the First and last LSN number against each database instance on MS SQL server.So the differentails backup becomes invalid becuase it seeks its full backup thru LSN number.

SO you get this messages so SQL Server Writer service should shutdown during wohle day so that it could not become invalid ur differential backup.

example :

your first backup thru SQL backup utility

DatabaseName First LSN LastLSN

AAA_Database 000012345 000012346

Differentail Backup off AAA_database

DatabaseName First LSN LastLSN

AAA_Database 000012347 000012348

your NTbackup utulity is running and SP2 of SQL and windows server has installed

DatabaseName First LSN LastLSN

AAA_Database 000012349 000012340

when urestore Differenail backup then u got the message deescribed in this thread. Because sql server detects that a latest full backup has done.

Solution is only shutdown ur SQL Writer Service.