database size

what is the max size an SQL Ce database can be on a handheld device?The maximum database size is 4GB (slightly less - 4091 KB).

database restore issue

I cannot restore a differential database backup on top of a full back up for
some reason. I am installing it on a seperate server from a "device" , i
dont know what I ma doing wrong. Obviously I am new to sql server
administration. Any help will be appreciated.
best
Jay
Also, please post the exact error message...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John" <anonymous@.discussions.microsoft.com> wrote in message news:22f7001c45e15$ba2d4670$a301280a@.phx.gbl...[vbcol=seagreen]
> Is there another backup between the full backup and
> differential backup?
>
> a full back up for
> a "device" , i
> sql server
|||No there isnt another backup between the Full and differential database
backup.
The exact error message is somehting of the effect that
"Microsoft SQL-DMO(ODBC SQL State:42000)
Cannot apply the backup on device 'D:\TestDB\x-D.bak' to database 'X'.
RESTORE DATABASE is terminating abnormally.
Its kinds frusterating because I dont know enough about the subject to be
able to troubleshoot this error convinceingly. I appreciate the help you
guys are offereing.
-Jay
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e5yevchXEHA.648@.TK2MSFTNGP10.phx.gbl...
> Also, please post the exact error message...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "John" <anonymous@.discussions.microsoft.com> wrote in message
news:22f7001c45e15$ba2d4670$a301280a@.phx.gbl...
>

database restore issue

I cannot restore a differential database backup on top of a full back up for
some reason. I am installing it on a seperate server from a "device" , i
dont know what I ma doing wrong. Obviously I am new to sql server
administration. Any help will be appreciated.
best
Jay
Also, please post the exact error message...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John" <anonymous@.discussions.microsoft.com> wrote in message news:22f7001c45e15$ba2d4670$a301280a@.phx.gbl...[vbcol=seagreen]
> Is there another backup between the full backup and
> differential backup?
>
> a full back up for
> a "device" , i
> sql server
|||No there isnt another backup between the Full and differential database
backup.
The exact error message is somehting of the effect that
"Microsoft SQL-DMO(ODBC SQL State:42000)
Cannot apply the backup on device 'D:\TestDB\x-D.bak' to database 'X'.
RESTORE DATABASE is terminating abnormally.
Its kinds frusterating because I dont know enough about the subject to be
able to troubleshoot this error convinceingly. I appreciate the help you
guys are offereing.
-Jay
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e5yevchXEHA.648@.TK2MSFTNGP10.phx.gbl...
> Also, please post the exact error message...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "John" <anonymous@.discussions.microsoft.com> wrote in message
news:22f7001c45e15$ba2d4670$a301280a@.phx.gbl...
>
|||Hi,
You have to restore the full database backup with "norecovery" and then
restoring the
differential with "recovery" option. If you have not specified the
NORECOVERY option during your
FULL backup restore , the database will become open and you will not be able
to apply a subsequent backups (
Differential or transaction log) above that
RESTORE Database <dbname> from disk='fullbackup' with NORECOVERY
go
RESTORE Database <dbname> from disk='diff_backup' with RECOVERY
Thanks
Hari
MCDBA
"Jay Taylor" <help4u@.gmail.com> wrote in message
news:uZqceShXEHA.3640@.TK2MSFTNGP11.phx.gbl...
> I cannot restore a differential database backup on top of a full back up
for
> some reason. I am installing it on a seperate server from a "device" , i
> dont know what I ma doing wrong. Obviously I am new to sql server
> administration. Any help will be appreciated.
> best
> Jay
>
|||I'm sorry but I can't really be of more help. I would triple check that you indeed work against the
correct backup files (also use RESTORE HEADERONLY), and that you really really don't have a database
backup in between. Also, do a simple test case against pubs or so, and verify that the test case
work as you expect.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jay Taylor" <help4u@.gmail.com> wrote in message news:OpEpnyjXEHA.648@.TK2MSFTNGP10.phx.gbl...
> No there isnt another backup between the Full and differential database
> backup.
> The exact error message is somehting of the effect that
> "Microsoft SQL-DMO(ODBC SQL State:42000)
> Cannot apply the backup on device 'D:\TestDB\x-D.bak' to database 'X'.
> RESTORE DATABASE is terminating abnormally.
> Its kinds frusterating because I dont know enough about the subject to be
> able to troubleshoot this error convinceingly. I appreciate the help you
> guys are offereing.
> -Jay
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:e5yevchXEHA.648@.TK2MSFTNGP10.phx.gbl...
> news:22f7001c45e15$ba2d4670$a301280a@.phx.gbl...
>

database restore issue

I cannot restore a differential database backup on top of a full back up for
some reason. I am installing it on a seperate server from a "device" , i
dont know what I ma doing wrong. Obviously I am new to sql server
administration. Any help will be appreciated.
best
JayHi,
You have to restore the full database backup with "norecovery" and then
restoring the
differential with "recovery" option. If you have not specified the
NORECOVERY option during your
FULL backup restore , the database will become open and you will not be able
to apply a subsequent backups (
Differential or transaction log) above that
RESTORE Database <dbname> from disk='fullbackup' with NORECOVERY
go
RESTORE Database <dbname> from disk='diff_backup' with RECOVERY
Thanks
Hari
MCDBA
"Jay Taylor" <help4u@.gmail.com> wrote in message
news:uZqceShXEHA.3640@.TK2MSFTNGP11.phx.gbl...
> I cannot restore a differential database backup on top of a full back up
for
> some reason. I am installing it on a seperate server from a "device" , i
> dont know what I ma doing wrong. Obviously I am new to sql server
> administration. Any help will be appreciated.
> best
> Jay
>

database restore issue

I cannot restore a differential database backup on top of a full back up for
some reason. I am installing it on a seperate server from a "device" , i
dont know what I ma doing wrong. Obviously I am new to sql server
administration. Any help will be appreciated.
best
JayAlso, please post the exact error message...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John" <anonymous@.discussions.microsoft.com> wrote in message news:22f7001c45e15$ba2d4670$a301280a@.phx.gbl...
> Is there another backup between the full backup and
> differential backup'
>
> >--Original Message--
> >I cannot restore a differential database backup on top of
> a full back up for
> >some reason. I am installing it on a seperate server from
> a "device" , i
> >dont know what I ma doing wrong. Obviously I am new to
> sql server
> >administration. Any help will be appreciated.
> >
> >best
> >Jay
> >
> >
> >.
> >|||No there isnt another backup between the Full and differential database
backup.
The exact error message is somehting of the effect that
"Microsoft SQL-DMO(ODBC SQL State:42000)
Cannot apply the backup on device 'D:\TestDB\x-D.bak' to database 'X'.
RESTORE DATABASE is terminating abnormally.
Its kinds frusterating because I dont know enough about the subject to be
able to troubleshoot this error convinceingly. I appreciate the help you
guys are offereing.
-Jay
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e5yevchXEHA.648@.TK2MSFTNGP10.phx.gbl...
> Also, please post the exact error message...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "John" <anonymous@.discussions.microsoft.com> wrote in message
news:22f7001c45e15$ba2d4670$a301280a@.phx.gbl...
> > Is there another backup between the full backup and
> > differential backup'
> >
> >
> >
> > >--Original Message--
> > >I cannot restore a differential database backup on top of
> > a full back up for
> > >some reason. I am installing it on a seperate server from
> > a "device" , i
> > >dont know what I ma doing wrong. Obviously I am new to
> > sql server
> > >administration. Any help will be appreciated.
> > >
> > >best
> > >Jay
> > >
> > >
> > >.
> > >
>|||Hi,
You have to restore the full database backup with "norecovery" and then
restoring the
differential with "recovery" option. If you have not specified the
NORECOVERY option during your
FULL backup restore , the database will become open and you will not be able
to apply a subsequent backups (
Differential or transaction log) above that
RESTORE Database <dbname> from disk='fullbackup' with NORECOVERY
go
RESTORE Database <dbname> from disk='diff_backup' with RECOVERY
Thanks
Hari
MCDBA
"Jay Taylor" <help4u@.gmail.com> wrote in message
news:uZqceShXEHA.3640@.TK2MSFTNGP11.phx.gbl...
> I cannot restore a differential database backup on top of a full back up
for
> some reason. I am installing it on a seperate server from a "device" , i
> dont know what I ma doing wrong. Obviously I am new to sql server
> administration. Any help will be appreciated.
> best
> Jay
>|||I'm sorry but I can't really be of more help. I would triple check that you indeed work against the
correct backup files (also use RESTORE HEADERONLY), and that you really really don't have a database
backup in between. Also, do a simple test case against pubs or so, and verify that the test case
work as you expect.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jay Taylor" <help4u@.gmail.com> wrote in message news:OpEpnyjXEHA.648@.TK2MSFTNGP10.phx.gbl...
> No there isnt another backup between the Full and differential database
> backup.
> The exact error message is somehting of the effect that
> "Microsoft SQL-DMO(ODBC SQL State:42000)
> Cannot apply the backup on device 'D:\TestDB\x-D.bak' to database 'X'.
> RESTORE DATABASE is terminating abnormally.
> Its kinds frusterating because I dont know enough about the subject to be
> able to troubleshoot this error convinceingly. I appreciate the help you
> guys are offereing.
> -Jay
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:e5yevchXEHA.648@.TK2MSFTNGP10.phx.gbl...
> > Also, please post the exact error message...
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "John" <anonymous@.discussions.microsoft.com> wrote in message
> news:22f7001c45e15$ba2d4670$a301280a@.phx.gbl...
> > > Is there another backup between the full backup and
> > > differential backup'
> > >
> > >
> > >
> > > >--Original Message--
> > > >I cannot restore a differential database backup on top of
> > > a full back up for
> > > >some reason. I am installing it on a seperate server from
> > > a "device" , i
> > > >dont know what I ma doing wrong. Obviously I am new to
> > > sql server
> > > >administration. Any help will be appreciated.
> > > >
> > > >best
> > > >Jay
> > > >
> > > >
> > > >.
> > > >
> >
> >
>

Database Restore Fails

HI to All!
I have posted previously that database resotre giving me Device
Activation Error which is solved. Now it is giving me the following
error:
Server: Msg 3270, Level 16, State 1, Line 1
An internal consistency error occurred. Contact Technical Support for
assistance.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Any Help!
Thanx
Farid
*** Sent via Developersdex http://www.developersdex.com ***You should do what the error say. There is a problem in the backup, open a case with MS Support and
see if they can handle it. Also, if the original database is still around, use DBCC CHECKDB to see
if it has any corruptions.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ghulam Farid" <gfaryd@.yahoo.com> wrote in message news:%23w63%23Zf2FHA.896@.TK2MSFTNGP09.phx.gbl...
>
> HI to All!
> I have posted previously that database resotre giving me Device
> Activation Error which is solved. Now it is giving me the following
> error:
> Server: Msg 3270, Level 16, State 1, Line 1
> An internal consistency error occurred. Contact Technical Support for
> assistance.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Any Help!
> Thanx
> Farid
>
> *** Sent via Developersdex http://www.developersdex.com ***|||Hi,
Execute DBCC CHECKDB in the source database where you took the backup. See
if there is any errors on it.
If you do not have the source database then open a case with microsoft and
seek their help in restore
Thanks
hari
SQL Server MVP
"Ghulam Farid" <gfaryd@.yahoo.com> wrote in message
news:%23w63%23Zf2FHA.896@.TK2MSFTNGP09.phx.gbl...
>
> HI to All!
> I have posted previously that database resotre giving me Device
> Activation Error which is solved. Now it is giving me the following
> error:
> Server: Msg 3270, Level 16, State 1, Line 1
> An internal consistency error occurred. Contact Technical Support for
> assistance.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Any Help!
> Thanx
> Farid
>
> *** Sent via Developersdex http://www.developersdex.com ***

database restore

How does the database restore work... ?
when a database is backed up and restored on a new device/server will that create new data pages?
or
Is it like uncompressing the data and index pages?
ThanksWhy does it matter?