DB Backup and restoration

Hi, There,
I am going to schedule the live database backup and restoration to the
remote site on daily basis.
The correct procedure:
1. Sunday full db backup-->Restored on remote server
2. Daily differential backup from Monday to Saturday--> Restored on remote
server with the same squence.
3. Again database was sync with full db backup on the 2nd Sunday.
However, for some reason, the following actual procedure happen:
1. Daily DB full backup at 5:00AM in the morning
2. Daily Differential backup at 4:50AM bf the full backup happen
3. Restore the sunday full DB on remote site
4. Followed by daily differential back which happen at 4:50am daily.
Due to the huge side of the DB, I could not ship the daily DB to the remote
site. And I hv problem to restore those differential backup, so I am
wondering whether this is possible, if not, How can I achiev the same.
Thanks for any information!
Shermaine
I am not sure for what purpose you are restoring this database, but for
large database you can look for option of replication or logshipping
or mirroring instead of copy backup daily and restore it.
Regards
Amish Shah
http://shahamishm.tripod.com
xiaomei wrote:
> Hi, There,
> I am going to schedule the live database backup and restoration to the
> remote site on daily basis.
> The correct procedure:
> 1. Sunday full db backup-->Restored on remote server
> 2. Daily differential backup from Monday to Saturday--> Restored on remote
> server with the same squence.
> 3. Again database was sync with full db backup on the 2nd Sunday.
> However, for some reason, the following actual procedure happen:
> 1. Daily DB full backup at 5:00AM in the morning
> 2. Daily Differential backup at 4:50AM bf the full backup happen
> 3. Restore the sunday full DB on remote site
> 4. Followed by daily differential back which happen at 4:50am daily.
> Due to the huge side of the DB, I could not ship the daily DB to the remote
> site. And I hv problem to restore those differential backup, so I am
> wondering whether this is possible, if not, How can I achiev the same.
> Thanks for any information!
> Shermaine
|||Hi, Amish,
The reason is the production server and develop team located in different
country.
Some time the develop team need check the live database, however we did not
allow them to direct connect the the live server.
Replication and logshipping via internet is very cost solution, we are not
going to implement that for this purpose only. And due to the huge size of
the DB, it is not psossible for sync the full db backup on daily baisis.
I schedule to upload the daily differential backup to remote office server
daily, and the following day, they will restore the backup there.
The DB full backup(5:00am) and differential backup (4:50am) happen daily, if
I only send the differential backup, will it works after the first time db
was sync with full db backup?
Thanks and best regards
Shermaine
"amish" wrote:

> I am not sure for what purpose you are restoring this database, but for
> large database you can look for option of replication or logshipping
> or mirroring instead of copy backup daily and restore it.
>
> Regards
> Amish Shah
> http://shahamishm.tripod.com
> xiaomei wrote:
>
|||According to BOL
A differential backup is based on the most recent, preceding data
backup, which is base backup.A differential backup records only the
data that has changed since its full backup. Before restoring a
differential backup, you must restore its full backup
You can schedule log shipping or create script to zip all log backup of
day and copy to destination server and restore them.
Regards
Amish Shah
http://shahamishm.tripod.com
On Jan 23, 6:21 pm, xiaomei <xiao...@.discussions.microsoft.com> wrote:[vbcol=seagreen]
> Hi, Amish,
> The reason is the production server and develop team located in different
> country.
> Some time the develop team need check the live database, however we did not
> allow them to direct connect the the live server.
> Replication and logshipping via internet is very cost solution, we are not
> going to implement that for this purpose only. And due to the huge size of
> the DB, it is not psossible for sync the full db backup on daily baisis.
> I schedule to upload the daily differential backup to remote office server
> daily, and the following day, they will restore the backup there.
> The DB full backup(5:00am) and differential backup (4:50am) happen daily, if
> I only send the differential backup, will it works after the first time db
> was sync with full db backup?
> Thanks and best regards
> Shermaine
>
> "amish" wrote:
>
>
>
|||Hi, Amish,
Does the Log shipping adopt the simliar technologies as differential backup?
I can schedule the log shipping, however, due to the daily DB full backup
happens on the live server, I aslo need sync the DB with full db backup
daily, because the transaction log also refer to last full db backup or
differential backup or earlier log backup. Else, the log could not be
restored.
Can you help to recommend some document of the difference of implement a log
shipping scheme and a differential bakcup solution, not very clear what are
the disavantages and benifit.
Thanks and regards
Shermaine
"amish" wrote:

> According to BOL
> A differential backup is based on the most recent, preceding data
> backup, which is base backup.A differential backup records only the
> data that has changed since its full backup. Before restoring a
> differential backup, you must restore its full backup
> You can schedule log shipping or create script to zip all log backup of
> day and copy to destination server and restore them.
> Regards
> Amish Shah
> http://shahamishm.tripod.com
> On Jan 23, 6:21 pm, xiaomei <xiao...@.discussions.microsoft.com> wrote:
>
sql

DB Backup and restoration

Hi, There,
I am going to schedule the live database backup and restoration to the
remote site on daily basis.
The correct procedure:
1. Sunday full db backup-->Restored on remote server
2. Daily differential backup from Monday to Saturday--> Restored on remote
server with the same squence.
3. Again database was sync with full db backup on the 2nd Sunday.
However, for some reason, the following actual procedure happen:
1. Daily DB full backup at 5:00AM in the morning
2. Daily Differential backup at 4:50AM bf the full backup happen
3. Restore the sunday full DB on remote site
4. Followed by daily differential back which happen at 4:50am daily.
Due to the huge side of the DB, I could not ship the daily DB to the remote
site. And I hv problem to restore those differential backup, so I am
wondering whether this is possible, if not, How can I achiev the same.
Thanks for any information!
ShermaineI am not sure for what purpose you are restoring this database, but for
large database you can look for option of replication or logshipping
or mirroring instead of copy backup daily and restore it.
Regards
Amish Shah
http://shahamishm.tripod.com
xiaomei wrote:
> Hi, There,
> I am going to schedule the live database backup and restoration to the
> remote site on daily basis.
> The correct procedure:
> 1. Sunday full db backup-->Restored on remote server
> 2. Daily differential backup from Monday to Saturday--> Restored on remote
> server with the same squence.
> 3. Again database was sync with full db backup on the 2nd Sunday.
> However, for some reason, the following actual procedure happen:
> 1. Daily DB full backup at 5:00AM in the morning
> 2. Daily Differential backup at 4:50AM bf the full backup happen
> 3. Restore the sunday full DB on remote site
> 4. Followed by daily differential back which happen at 4:50am daily.
> Due to the huge side of the DB, I could not ship the daily DB to the remote
> site. And I hv problem to restore those differential backup, so I am
> wondering whether this is possible, if not, How can I achiev the same.
> Thanks for any information!
> Shermaine|||According to BOL
A differential backup is based on the most recent, preceding data
backup, which is base backup.A differential backup records only the
data that has changed since its full backup. Before restoring a
differential backup, you must restore its full backup
You can schedule log shipping or create script to zip all log backup of
day and copy to destination server and restore them.
Regards
Amish Shah
http://shahamishm.tripod.com
On Jan 23, 6:21 pm, xiaomei <xiao...@.discussions.microsoft.com> wrote:
> Hi, Amish,
> The reason is the production server and develop team located in different
> country.
> Some time the develop team need check the live database, however we did not
> allow them to direct connect the the live server.
> Replication and logshipping via internet is very cost solution, we are not
> going to implement that for this purpose only. And due to the huge size of
> the DB, it is not psossible for sync the full db backup on daily baisis.
> I schedule to upload the daily differential backup to remote office server
> daily, and the following day, they will restore the backup there.
> The DB full backup(5:00am) and differential backup (4:50am) happen daily, if
> I only send the differential backup, will it works after the first time db
> was sync with full db backup?
> Thanks and best regards
> Shermaine
>
> "amish" wrote:
> > I am not sure for what purpose you are restoring this database, but for
> > large database you can look for option of replication or logshipping
> > or mirroring instead of copy backup daily and restore it.
> > Regards
> > Amish Shah
> >http://shahamishm.tripod.com
> > xiaomei wrote:
> > > Hi, There,
> > > I am going to schedule the live database backup and restoration to the
> > > remote site on daily basis.
> > > The correct procedure:
> > > 1. Sunday full db backup-->Restored on remote server
> > > 2. Daily differential backup from Monday to Saturday--> Restored on remote
> > > server with the same squence.
> > > 3. Again database was sync with full db backup on the 2nd Sunday.
> > > However, for some reason, the following actual procedure happen:
> > > 1. Daily DB full backup at 5:00AM in the morning
> > > 2. Daily Differential backup at 4:50AM bf the full backup happen
> > > 3. Restore the sunday full DB on remote site
> > > 4. Followed by daily differential back which happen at 4:50am daily.
> > > Due to the huge side of the DB, I could not ship the daily DB to the remote
> > > site. And I hv problem to restore those differential backup, so I am
> > > wondering whether this is possible, if not, How can I achiev the same.
> > > Thanks for any information!
> > > Shermaine- Hide quoted text -- Show quoted text -|||Hi, Amish,
Does the Log shipping adopt the simliar technologies as differential backup?
I can schedule the log shipping, however, due to the daily DB full backup
happens on the live server, I aslo need sync the DB with full db backup
daily, because the transaction log also refer to last full db backup or
differential backup or earlier log backup. Else, the log could not be
restored.
Can you help to recommend some document of the difference of implement a log
shipping scheme and a differential bakcup solution, not very clear what are
the disavantages and benifit.
Thanks and regards
Shermaine
"amish" wrote:
> According to BOL
> A differential backup is based on the most recent, preceding data
> backup, which is base backup.A differential backup records only the
> data that has changed since its full backup. Before restoring a
> differential backup, you must restore its full backup
> You can schedule log shipping or create script to zip all log backup of
> day and copy to destination server and restore them.
> Regards
> Amish Shah
> http://shahamishm.tripod.com
> On Jan 23, 6:21 pm, xiaomei <xiao...@.discussions.microsoft.com> wrote:
> > Hi, Amish,
> > The reason is the production server and develop team located in different
> > country.
> > Some time the develop team need check the live database, however we did not
> > allow them to direct connect the the live server.
> >
> > Replication and logshipping via internet is very cost solution, we are not
> > going to implement that for this purpose only. And due to the huge size of
> > the DB, it is not psossible for sync the full db backup on daily baisis.
> > I schedule to upload the daily differential backup to remote office server
> > daily, and the following day, they will restore the backup there.
> >
> > The DB full backup(5:00am) and differential backup (4:50am) happen daily, if
> > I only send the differential backup, will it works after the first time db
> > was sync with full db backup?
> >
> > Thanks and best regards
> > Shermaine
> >
> >
> >
> > "amish" wrote:
> > > I am not sure for what purpose you are restoring this database, but for
> > > large database you can look for option of replication or logshipping
> > > or mirroring instead of copy backup daily and restore it.
> >
> > > Regards
> > > Amish Shah
> > >http://shahamishm.tripod.com
> >
> > > xiaomei wrote:
> > > > Hi, There,
> > > > I am going to schedule the live database backup and restoration to the
> > > > remote site on daily basis.
> > > > The correct procedure:
> > > > 1. Sunday full db backup-->Restored on remote server
> > > > 2. Daily differential backup from Monday to Saturday--> Restored on remote
> > > > server with the same squence.
> > > > 3. Again database was sync with full db backup on the 2nd Sunday.
> >
> > > > However, for some reason, the following actual procedure happen:
> >
> > > > 1. Daily DB full backup at 5:00AM in the morning
> > > > 2. Daily Differential backup at 4:50AM bf the full backup happen
> > > > 3. Restore the sunday full DB on remote site
> > > > 4. Followed by daily differential back which happen at 4:50am daily.
> >
> > > > Due to the huge side of the DB, I could not ship the daily DB to the remote
> > > > site. And I hv problem to restore those differential backup, so I am
> > > > wondering whether this is possible, if not, How can I achiev the same.
> >
> > > > Thanks for any information!
> >
> > > > Shermaine- Hide quoted text -- Show quoted text -
>|||Log backup is backup of transaction logs.
Logshipping you have to first restore full backup and then all
consecutive transaction log backup. transaction log backup sequence
does not get affected by later on full backup and you dont need to
restore full backup again at destination.
First you should look at different type of backup in Books Online.
Then look at Logshipping. BOL has plenty of information for both.
Regards
Amish Shah
http://shahamishm.tripod.com
On Jan 25, 8:37 am, xiaomei <xiao...@.discussions.microsoft.com> wrote:
> Hi, Amish,
> Does the Log shipping adopt the simliar technologies as differential backup?
> I can schedule the log shipping, however, due to the daily DB full backup
> happens on the live server, I aslo need sync the DB with full db backup
> daily, because the transaction log also refer to last full db backup or
> differential backup or earlier log backup. Else, the log could not be
> restored.
> Can you help to recommend some document of the difference of implement a log
> shipping scheme and a differential bakcup solution, not very clear what are
> the disavantages and benifit.
> Thanks and regards
> Shermaine
>
> "amish" wrote:
> > According to BOL
> > A differential backup is based on the most recent, preceding data
> > backup, which is base backup.A differential backup records only the
> > data that has changed since its full backup. Before restoring a
> > differential backup, you must restore its full backup
> > You can schedule log shipping or create script to zip all log backup of
> > day and copy to destination server and restore them.
> > Regards
> > Amish Shah
> >http://shahamishm.tripod.com
> > On Jan 23, 6:21 pm, xiaomei <xiao...@.discussions.microsoft.com> wrote:
> > > Hi, Amish,
> > > The reason is the production server and develop team located in different
> > > country.
> > > Some time the develop team need check the live database, however we did not
> > > allow them to direct connect the the live server.
> > > Replication and logshipping via internet is very cost solution, we are not
> > > going to implement that for this purpose only. And due to the huge size of
> > > the DB, it is not psossible for sync the full db backup on daily baisis.
> > > I schedule to upload the daily differential backup to remote office server
> > > daily, and the following day, they will restore the backup there.
> > > The DB full backup(5:00am) and differential backup (4:50am) happen daily, if
> > > I only send the differential backup, will it works after the first time db
> > > was sync with full db backup?
> > > Thanks and best regards
> > > Shermaine
> > > "amish" wrote:
> > > > I am not sure for what purpose you are restoring this database, but for
> > > > large database you can look for option of replication or logshipping
> > > > or mirroring instead of copy backup daily and restore it.
> > > > Regards
> > > > Amish Shah
> > > >http://shahamishm.tripod.com
> > > > xiaomei wrote:
> > > > > Hi, There,
> > > > > I am going to schedule the live database backup and restoration to the
> > > > > remote site on daily basis.
> > > > > The correct procedure:
> > > > > 1. Sunday full db backup-->Restored on remote server
> > > > > 2. Daily differential backup from Monday to Saturday--> Restored on remote
> > > > > server with the same squence.
> > > > > 3. Again database was sync with full db backup on the 2nd Sunday.
> > > > > However, for some reason, the following actual procedure happen:
> > > > > 1. Daily DB full backup at 5:00AM in the morning
> > > > > 2. Daily Differential backup at 4:50AM bf the full backup happen
> > > > > 3. Restore the sunday full DB on remote site
> > > > > 4. Followed by daily differential back which happen at 4:50am daily.
> > > > > Due to the huge side of the DB, I could not ship the daily DB to the remote
> > > > > site. And I hv problem to restore those differential backup, so I am
> > > > > wondering whether this is possible, if not, How can I achiev the same.
> > > > > Thanks for any information!
> > > > > Shermaine- Hide quoted text -- Show quoted text -- Hide quoted text -- Show quoted text -

DB Backup and restoration

Hi, There,
I am going to schedule the live database backup and restoration to the
remote site on daily basis.
The correct procedure:
1. Sunday full db backup-->Restored on remote server
2. Daily differential backup from Monday to Saturday--> Restored on remote
server with the same squence.
3. Again database was sync with full db backup on the 2nd Sunday.
However, for some reason, the following actual procedure happen:
1. Daily DB full backup at 5:00AM in the morning
2. Daily Differential backup at 4:50AM bf the full backup happen
3. Restore the sunday full DB on remote site
4. Followed by daily differential back which happen at 4:50am daily.
Due to the huge side of the DB, I could not ship the daily DB to the remote
site. And I hv problem to restore those differential backup, so I am
wondering whether this is possible, if not, How can I achiev the same.
Thanks for any information!
ShermaineI am not sure for what purpose you are restoring this database, but for
large database you can look for option of replication or logshipping
or mirroring instead of copy backup daily and restore it.
Regards
Amish Shah
http://shahamishm.tripod.com
xiaomei wrote:
> Hi, There,
> I am going to schedule the live database backup and restoration to the
> remote site on daily basis.
> The correct procedure:
> 1. Sunday full db backup-->Restored on remote server
> 2. Daily differential backup from Monday to Saturday--> Restored on remot
e
> server with the same squence.
> 3. Again database was sync with full db backup on the 2nd Sunday.
> However, for some reason, the following actual procedure happen:
> 1. Daily DB full backup at 5:00AM in the morning
> 2. Daily Differential backup at 4:50AM bf the full backup happen
> 3. Restore the sunday full DB on remote site
> 4. Followed by daily differential back which happen at 4:50am daily.
> Due to the huge side of the DB, I could not ship the daily DB to the remo
te
> site. And I hv problem to restore those differential backup, so I am
> wondering whether this is possible, if not, How can I achiev the same.
> Thanks for any information!
> Shermaine|||Hi, Amish,
The reason is the production server and develop team located in different
country.
Some time the develop team need check the live database, however we did not
allow them to direct connect the the live server.
Replication and logshipping via internet is very cost solution, we are not
going to implement that for this purpose only. And due to the huge size of
the DB, it is not psossible for sync the full db backup on daily baisis.
I schedule to upload the daily differential backup to remote office server
daily, and the following day, they will restore the backup there.
The DB full backup(5:00am) and differential backup (4:50am) happen daily, if
I only send the differential backup, will it works after the first time db
was sync with full db backup?
Thanks and best regards
Shermaine
"amish" wrote:

> I am not sure for what purpose you are restoring this database, but for
> large database you can look for option of replication or logshipping
> or mirroring instead of copy backup daily and restore it.
>
> Regards
> Amish Shah
> http://shahamishm.tripod.com
> xiaomei wrote:
>|||According to BOL
A differential backup is based on the most recent, preceding data
backup, which is base backup.A differential backup records only the
data that has changed since its full backup. Before restoring a
differential backup, you must restore its full backup
You can schedule log shipping or create script to zip all log backup of
day and copy to destination server and restore them.
Regards
Amish Shah
http://shahamishm.tripod.com
On Jan 23, 6:21 pm, xiaomei <xiao...@.discussions.microsoft.com> wrote:[vbcol=seagreen]
> Hi, Amish,
> The reason is the production server and develop team located in different
> country.
> Some time the develop team need check the live database, however we did no
t
> allow them to direct connect the the live server.
> Replication and logshipping via internet is very cost solution, we are not
> going to implement that for this purpose only. And due to the huge size of
> the DB, it is not psossible for sync the full db backup on daily baisis.
> I schedule to upload the daily differential backup to remote office server
> daily, and the following day, they will restore the backup there.
> The DB full backup(5:00am) and differential backup (4:50am) happen daily,
if
> I only send the differential backup, will it works after the first time db
> was sync with full db backup?
> Thanks and best regards
> Shermaine
>
> "amish" wrote:
>
>
>
>
>
>
>|||Hi, Amish,
Does the Log shipping adopt the simliar technologies as differential backup?
I can schedule the log shipping, however, due to the daily DB full backup
happens on the live server, I aslo need sync the DB with full db backup
daily, because the transaction log also refer to last full db backup or
differential backup or earlier log backup. Else, the log could not be
restored.
Can you help to recommend some document of the difference of implement a log
shipping scheme and a differential bakcup solution, not very clear what are
the disavantages and benifit.
Thanks and regards
Shermaine
"amish" wrote:

> According to BOL
> A differential backup is based on the most recent, preceding data
> backup, which is base backup.A differential backup records only the
> data that has changed since its full backup. Before restoring a
> differential backup, you must restore its full backup
> You can schedule log shipping or create script to zip all log backup of
> day and copy to destination server and restore them.
> Regards
> Amish Shah
> http://shahamishm.tripod.com
> On Jan 23, 6:21 pm, xiaomei <xiao...@.discussions.microsoft.com> wrote:
>|||Log backup is backup of transaction logs.
Logshipping you have to first restore full backup and then all
consecutive transaction log backup. transaction log backup sequence
does not get affected by later on full backup and you dont need to
restore full backup again at destination.
First you should look at different type of backup in Books Online.
Then look at Logshipping. BOL has plenty of information for both.
Regards
Amish Shah
http://shahamishm.tripod.com
On Jan 25, 8:37 am, xiaomei <xiao...@.discussions.microsoft.com> wrote:[vbcol=seagreen]
> Hi, Amish,
> Does the Log shipping adopt the simliar technologies as differential backu
p?
> I can schedule the log shipping, however, due to the daily DB full backup
> happens on the live server, I aslo need sync the DB with full db backup
> daily, because the transaction log also refer to last full db backup or
> differential backup or earlier log backup. Else, the log could not be
> restored.
> Can you help to recommend some document of the difference of implement a l
og
> shipping scheme and a differential bakcup solution, not very clear what ar
e
> the disavantages and benifit.
> Thanks and regards
> Shermaine
>
> "amish" wrote:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>

DateTime Format / Language Problem

Hi,
I'm having a problem with the datetime format in RS. I live in Canada but
want to use the "en-US" language setting because most of our clients using
the app are in the States. What I'm doing is formatting a start and end date
parameter from a .NET calendar control with "MM/DD/YYYY" before sending it
to the report for generation. If the user has "en-US" selected as their
language in IE, the report runs great. If they have "en-CA" selected as
their language, the month and day displays backwards, so Aug 25, 2004 shows
up as 24/8/2004 which crashes the report (obviously because there isn't a
24th month).
So I specified "en-US" in the report definition language property, I
included rs:ParameterLanguage=en-US in my URL call and I pasted the
following code into my global.asax file under BeginRequest to convert
threads to use "en-US":
Thread.CurrentThread.CurrentCulture = New CultureInfo("en-US")
Nothing seems to be working...Am I missing something? Thanks,I just wanted to add to my post that the main toolbar is visible and
parameter toolbar is NOT visible.
Now if i hide the main toolbar, so both toolbars are hidden, the dates come
out properly and the report works regardless if the browser is set to
"en-US" or "en-CA".
Why does the visibility of the toolbars have anything to do with the way the
datetime format is displayed? We need to hide the parameter toolbar and show
the main toolbar for this particular application, but then the date gets
mixed up and the report won't work. Is this a bug?
"RS Developer" <idroppeddabomb@.hotmail.com> wrote in message
news:eXhvC$siEHA.2760@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I'm having a problem with the datetime format in RS. I live in Canada but
> want to use the "en-US" language setting because most of our clients using
> the app are in the States. What I'm doing is formatting a start and end
date
> parameter from a .NET calendar control with "MM/DD/YYYY" before sending it
> to the report for generation. If the user has "en-US" selected as their
> language in IE, the report runs great. If they have "en-CA" selected as
> their language, the month and day displays backwards, so Aug 25, 2004
shows
> up as 24/8/2004 which crashes the report (obviously because there isn't a
> 24th month).
> So I specified "en-US" in the report definition language property, I
> included rs:ParameterLanguage=en-US in my URL call and I pasted the
> following code into my global.asax file under BeginRequest to convert
> threads to use "en-US":
> Thread.CurrentThread.CurrentCulture = New CultureInfo("en-US")
> Nothing seems to be working...Am I missing something? Thanks,
>|||Instead of using the .NET calendar control, have you considered modifying
the SQL statement and using either 102 is ANSI (yy/mm/dd), but 103 is
British/French (dd/mm/yy).
WHERE (CONVERT(varchar(10), time, 102) = CONVERT(varchar(10),
DATEADD(dd, - 2, { fn NOW() }), 102))
CONVERT(varchar(10), CONVERT(varchar(4), DATEPART(yy, time)) + '/' +
CONVERT(varchar(2), DATEPART(mm, time)) + '/' + CONVERT(varchar(2),
DATEPART(dd, time)), 102)
Rory
"RS Developer" <idroppeddabomb@.hotmail.com> wrote in message
news:eB8BNKtiEHA.2544@.TK2MSFTNGP10.phx.gbl...
> I just wanted to add to my post that the main toolbar is visible and
> parameter toolbar is NOT visible.
> Now if i hide the main toolbar, so both toolbars are hidden, the dates
come
> out properly and the report works regardless if the browser is set to
> "en-US" or "en-CA".
> Why does the visibility of the toolbars have anything to do with the way
the
> datetime format is displayed? We need to hide the parameter toolbar and
show
> the main toolbar for this particular application, but then the date gets
> mixed up and the report won't work. Is this a bug?
>
> "RS Developer" <idroppeddabomb@.hotmail.com> wrote in message
> news:eXhvC$siEHA.2760@.TK2MSFTNGP15.phx.gbl...
> > Hi,
> >
> > I'm having a problem with the datetime format in RS. I live in Canada
but
> > want to use the "en-US" language setting because most of our clients
using
> > the app are in the States. What I'm doing is formatting a start and end
> date
> > parameter from a .NET calendar control with "MM/DD/YYYY" before sending
it
> > to the report for generation. If the user has "en-US" selected as their
> > language in IE, the report runs great. If they have "en-CA" selected as
> > their language, the month and day displays backwards, so Aug 25, 2004
> shows
> > up as 24/8/2004 which crashes the report (obviously because there isn't
a
> > 24th month).
> >
> > So I specified "en-US" in the report definition language property, I
> > included rs:ParameterLanguage=en-US in my URL call and I pasted the
> > following code into my global.asax file under BeginRequest to convert
> > threads to use "en-US":
> >
> > Thread.CurrentThread.CurrentCulture = New CultureInfo("en-US")
> >
> > Nothing seems to be working...Am I missing something? Thanks,
> >
> >
>|||Rory, thanks for your suggestion. Our client requested a graphical calendar
to pick dates so unfortunately I have to use the calendar control. The
problem for some reason is tied into the visibility of the toolbars, these
are the only combinations of visibility where the date gets formatted
properly (why the visibility of the toolbar is affecting date formatting is
beyond me):
Parameter = false, toolbar=false
Parameter = true, toolbar=true
Parameter = collapse , toolbar=true
However I need:
Parameter = false, toolbar=true
but then the date gets switched to dd/mm/yyyy and the report crashes...
"Rory McCaw" <mccawr@.rogers.com> wrote in message
news:ejYdThtiEHA.4020@.TK2MSFTNGP10.phx.gbl...
> Instead of using the .NET calendar control, have you considered modifying
> the SQL statement and using either 102 is ANSI (yy/mm/dd), but 103 is
> British/French (dd/mm/yy).
> WHERE (CONVERT(varchar(10), time, 102) = CONVERT(varchar(10),
> DATEADD(dd, - 2, { fn NOW() }), 102))
> CONVERT(varchar(10), CONVERT(varchar(4), DATEPART(yy, time)) + '/' +
> CONVERT(varchar(2), DATEPART(mm, time)) + '/' + CONVERT(varchar(2),
> DATEPART(dd, time)), 102)
> Rory
> "RS Developer" <idroppeddabomb@.hotmail.com> wrote in message
> news:eB8BNKtiEHA.2544@.TK2MSFTNGP10.phx.gbl...
> > I just wanted to add to my post that the main toolbar is visible and
> > parameter toolbar is NOT visible.
> >
> > Now if i hide the main toolbar, so both toolbars are hidden, the dates
> come
> > out properly and the report works regardless if the browser is set to
> > "en-US" or "en-CA".
> >
> > Why does the visibility of the toolbars have anything to do with the way
> the
> > datetime format is displayed? We need to hide the parameter toolbar and
> show
> > the main toolbar for this particular application, but then the date gets
> > mixed up and the report won't work. Is this a bug?
> >
> >
> > "RS Developer" <idroppeddabomb@.hotmail.com> wrote in message
> > news:eXhvC$siEHA.2760@.TK2MSFTNGP15.phx.gbl...
> > > Hi,
> > >
> > > I'm having a problem with the datetime format in RS. I live in Canada
> but
> > > want to use the "en-US" language setting because most of our clients
> using
> > > the app are in the States. What I'm doing is formatting a start and
end
> > date
> > > parameter from a .NET calendar control with "MM/DD/YYYY" before
sending
> it
> > > to the report for generation. If the user has "en-US" selected as
their
> > > language in IE, the report runs great. If they have "en-CA" selected
as
> > > their language, the month and day displays backwards, so Aug 25, 2004
> > shows
> > > up as 24/8/2004 which crashes the report (obviously because there
isn't
> a
> > > 24th month).
> > >
> > > So I specified "en-US" in the report definition language property, I
> > > included rs:ParameterLanguage=en-US in my URL call and I pasted the
> > > following code into my global.asax file under BeginRequest to convert
> > > threads to use "en-US":
> > >
> > > Thread.CurrentThread.CurrentCulture = New CultureInfo("en-US")
> > >
> > > Nothing seems to be working...Am I missing something? Thanks,
> > >
> > >
> >
> >
>

Dateformat problem in Query Analyser

Hi Everybody,
i have a small problem ?
i have a two different servers
one is used for test purposes and the other one is used for live proposes

i have a table call Employee in both the servers and i got a filed call Attnd_Dttm

so when i open a query analyzer from the test database and type
select * from Employee where convert(datetime,Attnd_Dttm) like '13/01/2005'
i am getting the correct results

but when i am type the same SQL from the live databse
select * from Employee where convert(datetime,Attnd_Dttm) like '13/01/2005'
it give me the
"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value."

My problem is how come this happen ,cos i checked form the live database server computer it's using a British standard date time format like dd/mm/yyyyy ?

Any Idea to solve this problem,cos i need to run the same SQL in both the servers without any problems ?

regards
suis

Try using this date format: 2005-01-13. (year, month, day, dash-separated). This format seems to work in all localizations.

-Ryan / Kardax

|||Hi Ryan
u r reply is not clear to me,
where can i give this command !

is there any command to find out the sql server date time format
regards
suis
|||

I think that you have differenet default DATEFORMAT option on your servers.

You could use SET SET DATEFORMAT 'mdy'

Or use explicit convert:

select * from Employee where convert(datetime,Attnd_Dttm,103) like '13/01/2005'

|||HI Konstantin Kosinsky
Thanks very much for your comments
u r solution is worked out,
but is there any command to check SQL server DateTime fornat ?

regards
suis

|||

suis,

I wonder if you could alter that column a make it datetime data type. If you can not change the data type of that column, I will suggest to store the value using ISO ('yyyymmdd') or ISO8601 ('yyyy-mm-ddThh:mis.mmm'). This way, SQL Server can interpret the string as a datetime no matter the language or formatdate settings.

Code Snippet

set dateformat dmy

go

select cast('2007-05-13T08:15:45.997' as datetime)

go

set dateformat mdy

go

select cast('2007-05-13T08:15:45.997' as datetime)

go

set language Spanish

go

select cast('2007-05-13T08:15:45.997' as datetime)

go

set language English

go

select cast('2007-05-13T08:15:45.997' as datetime)

go

AMB