Backup to Network Drive: standard

Showing posts with label standard. Show all posts

Thursday, March 22, 2012

Barcode font not exporting to PDF

I have a report that uses a barcode font and it works good in the standard HTML Report but it is blank when I export it to PDF. It also works when i export to tif or excel, but it fails when i goto pdf - Any ideas?Hi xhomerx,
Can you please let me know how you embedded barcode font in SQL Server Reporting Services. I have barcode font in "C:\WINNT\FONTS" but it does not appear in SQL Server R S, rather it does in MS Office.
Your help is much appreciated

Thanks,
Krishna|||Did you install the Bar Coding Font on the Computer that is running Report Services? I am not verrified that this is the problem, but it is a logical place to start. Let me know if this doesnt work and i will do some tests over here to see exactly what u need.

Im still having the problem with the Bar Codes not being showed in PDF tho - Any ideas Anyone?|||

Xhomerx,

I have installed barcode font on my machine and I dont know how to see this barcode in reporting service. Can you pl let me know the process?

Thanks,
Krishna

|||

I have a report that uses a barcode font and it works good in thestandard HTML Report but it is blank when I export it to PDF.

It is a known defect/drawback in SQL RS. When I worked at my previouscompany we had a similar problem. We had plenty of talks with Microsoft( our company was a premiere customer) still we havent been able to geta proper response from MS. On another note I found a third party toolthat solves this issue. Cant remember the name off the top of my headwill post back if I remember.
sql

Barcode doesn't print from reports server

Hi there,

Ok, so I have a report that is generating product labels on a standard mailing lable sheet (30 of them on a 8.5X11 sheet of stock). The whole process works just fine even the printing of the bar codes when I am printing the lables from VS2005's Preview function. However, when I moved the report to our reports server and run the same report, the barcodes don't print out. I have checked, and the barcode font has been installed on the server.

Any suggestions would be greatly appreciated. Thanks! - Eric-

Can you tell me how you got the labels to print correctly.

I can't seem to get mine lined up. I am trying to print Avery 5160 which is also 30 labels.

Thanks

Crystal

|||Crystal, Where are you in the process? Have you gotten the data to print in three columns? Let me know and I will try to dial you in. :-)|||

I do have the data printing in 3 columns but only if I export it to PDF first. The preview only shows one column.

My alignment is off vertically. It starts out fine but after the 3rd row its off. Thanks for any help!

|||

Hi,

I am trying to display the barcode on a webfor for a tracking number, How do I display it.

I am new to asp.net, but i have to get this done.

Thank you,

|||

I have tried using barcode fonts without much success.

However I did find a product which works very well and I highly recommend it.

THe only caveat to using this product is if you upgrade it you need to go back and upgrade all your other reports that use the older version.

the product is neodynamic barcode professional 3.0 for reporting services.|||

is there any method which I can use to convert a dll designed for windows forms, to web forms.

this is a free dll supplied by ID automation.

Barcode doesn't print from reports server

Hi there,

Any suggestions would be greatly appreciated. Thanks! - Eric-

Can you tell me how you got the labels to print correctly.

I can't seem to get mine lined up. I am trying to print Avery 5160 which is also 30 labels.

Thanks

Crystal

|||Crystal, Where are you in the process? Have you gotten the data to print in three columns? Let me know and I will try to dial you in. :-)|||

I do have the data printing in 3 columns but only if I export it to PDF first. The preview only shows one column.

My alignment is off vertically. It starts out fine but after the 3rd row its off. Thanks for any help!

|||

Hi,

I am trying to display the barcode on a webfor for a tracking number, How do I display it.

I am new to asp.net, but i have to get this done.

Thank you,

|||

I have tried using barcode fonts without much success.

However I did find a product which works very well and I highly recommend it.

THe only caveat to using this product is if you upgrade it you need to go back and upgrade all your other reports that use the older version.

the product is neodynamic barcode professional 3.0 for reporting services.|||

is there any method which I can use to convert a dll designed for windows forms, to web forms.

this is a free dll supplied by ID automation.

Barcode doesn't print from reports server

Hi there,

Any suggestions would be greatly appreciated. Thanks! - Eric-

Can you tell me how you got the labels to print correctly.

I can't seem to get mine lined up. I am trying to print Avery 5160 which is also 30 labels.

Thanks

Crystal

|||Crystal, Where are you in the process? Have you gotten the data to print in three columns? Let me know and I will try to dial you in. :-)|||

I do have the data printing in 3 columns but only if I export it to PDF first. The preview only shows one column.

My alignment is off vertically. It starts out fine but after the 3rd row its off. Thanks for any help!

|||

Hi,

I am trying to display the barcode on a webfor for a tracking number, How do I display it.

I am new to asp.net, but i have to get this done.

Thank you,

|||

I have tried using barcode fonts without much success.

However I did find a product which works very well and I highly recommend it.

THe only caveat to using this product is if you upgrade it you need to go back and upgrade all your other reports that use the older version.

the product is neodynamic barcode professional 3.0 for reporting services.|||

is there any method which I can use to convert a dll designed for windows forms, to web forms.

this is a free dll supplied by ID automation.

Thursday, March 8, 2012

Backups...daily

Hi,
When using the default backup tool and scheduling them nightly that come
with SQL 2000 Standard Edition are we getting good backups on a daily basis?
Meaning usable data for a restore in the event of disaster, I was told by
an associate that we are getting worthless backups without Backupexe.
Also, I know that we have other solutions by backing up the log files
assuming that the database is not set to "Simple". Suggestions?
Thanks!Hi,
SQL Server Standard backup is allways safe. So do not worry. If it is a
production database you could set the recovery model to "FULL"
and do a Transaction log backup every 30 minutes. Every night you could do a
Differential or FULL database backup.
Transaction log backup with FULL recovery model will allow you to recover
the database fully in the eve of a crash as well
as you could do a POINT_IN_TIME recovery.
SEE THE BELOW SITE FOR BACKUP AND RECOVERY STRATEGY:-
http://www1.us.dell.com/content/topics/global.aspx/power/en/ps4q00_martin?c=us&cs=555&l=en&s=biz
Thanks
Hari
SQL Server MVP
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:%23rrTM$zgFHA.3540@.TK2MSFTNGP12.phx.gbl...
> Hi,
> When using the default backup tool and scheduling them nightly that come
> with SQL 2000 Standard Edition are we getting good backups on a daily
> basis? Meaning usable data for a restore in the event of disaster, I was
> told by an associate that we are getting worthless backups without
> Backupexe.
> Also, I know that we have other solutions by backing up the log files
> assuming that the database is not set to "Simple". Suggestions?
> Thanks!
>|||Thank you!
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eEg2wG0gFHA.2880@.TK2MSFTNGP09.phx.gbl...
> Hi,
> SQL Server Standard backup is allways safe. So do not worry. If it is a
> production database you could set the recovery model to "FULL"
> and do a Transaction log backup every 30 minutes. Every night you could do
> a Differential or FULL database backup.
> Transaction log backup with FULL recovery model will allow you to recover
> the database fully in the eve of a crash as well
> as you could do a POINT_IN_TIME recovery.
> SEE THE BELOW SITE FOR BACKUP AND RECOVERY STRATEGY:-
> http://www1.us.dell.com/content/topics/global.aspx/power/en/ps4q00_martin?c=us&cs=555&l=en&s=biz
>
> Thanks
> Hari
> SQL Server MVP
>
> "Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
> news:%23rrTM$zgFHA.3540@.TK2MSFTNGP12.phx.gbl...
>> Hi,
>> When using the default backup tool and scheduling them nightly that come
>> with SQL 2000 Standard Edition are we getting good backups on a daily
>> basis? Meaning usable data for a restore in the event of disaster, I was
>> told by an associate that we are getting worthless backups without
>> Backupexe.
>> Also, I know that we have other solutions by backing up the log files
>> assuming that the database is not set to "Simple". Suggestions?
>> Thanks!
>|||Are you backing up to the same drive that youre db is on? If so, yes it is
worthless.
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:%23rrTM$zgFHA.3540@.TK2MSFTNGP12.phx.gbl...
> Hi,
> When using the default backup tool and scheduling them nightly that come
> with SQL 2000 Standard Edition are we getting good backups on a daily
> basis? Meaning usable data for a restore in the event of disaster, I was
> told by an associate that we are getting worthless backups without
> Backupexe.
> Also, I know that we have other solutions by backing up the log files
> assuming that the database is not set to "Simple". Suggestions?
> Thanks!
>|||You say it's worthless because of the obvious hard drive failures or some
other reason?
"ChrisR" <noemail@.bla.com> wrote in message
news:e9V9AN0gFHA.1468@.TK2MSFTNGP14.phx.gbl...
> Are you backing up to the same drive that youre db is on? If so, yes it is
> worthless.
>
> "Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
> news:%23rrTM$zgFHA.3540@.TK2MSFTNGP12.phx.gbl...
>> Hi,
>> When using the default backup tool and scheduling them nightly that come
>> with SQL 2000 Standard Edition are we getting good backups on a daily
>> basis? Meaning usable data for a restore in the event of disaster, I was
>> told by an associate that we are getting worthless backups without
>> Backupexe.
>> Also, I know that we have other solutions by backing up the log files
>> assuming that the database is not set to "Simple". Suggestions?
>> Thanks!
>|||The obvious hard drive failures.
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:uBrFAl0gFHA.2904@.tk2msftngp13.phx.gbl...
> You say it's worthless because of the obvious hard drive failures or some
> other reason?
> "ChrisR" <noemail@.bla.com> wrote in message
> news:e9V9AN0gFHA.1468@.TK2MSFTNGP14.phx.gbl...
>> Are you backing up to the same drive that youre db is on? If so, yes it
>> is worthless.
>>
>> "Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
>> news:%23rrTM$zgFHA.3540@.TK2MSFTNGP12.phx.gbl...
>> Hi,
>> When using the default backup tool and scheduling them nightly that come
>> with SQL 2000 Standard Edition are we getting good backups on a daily
>> basis? Meaning usable data for a restore in the event of disaster, I
>> was told by an associate that we are getting worthless backups without
>> Backupexe.
>> Also, I know that we have other solutions by backing up the log files
>> assuming that the database is not set to "Simple". Suggestions?
>> Thanks!
>>
>

Backups...daily

Backups with Maintenance Plans

Hi
I am new to database administration, and I am considering my options
for backups. We are using SQL Server 2005 Standard.
I have done some reading and have determined the right backup scheme
for us is a weekly complete Simple backup with daily Differential
backups.
I would like to set this up with a Maintenance Plan. How do I do this?
- do I set up two Maintenance Plans, one with the weekly backup and
one with the differentials?
- or do I do this with one Plan?
- or is this not possible with Maintenance Plans, in which case I
should just schedule an agent with SQL scripts?
thanks,
TJHi,
You can create a Maintenance Plan for the weekly full backups and another
one for the daily differential backups.
Also, if your databases are smaller than, let us say, 100 or 200 GB perhaps
you can try daily full backups, depending on your backup window.
Hope this helps,
Ben Nevarez
"TJ" wrote:
> Hi
> I am new to database administration, and I am considering my options
> for backups. We are using SQL Server 2005 Standard.
> I have done some reading and have determined the right backup scheme
> for us is a weekly complete Simple backup with daily Differential
> backups.
> I would like to set this up with a Maintenance Plan. How do I do this?
> - do I set up two Maintenance Plans, one with the weekly backup and
> one with the differentials?
> - or do I do this with one Plan?
> - or is this not possible with Maintenance Plans, in which case I
> should just schedule an agent with SQL scripts?
> thanks,
> TJ
>|||ok, thanks
Yeah, the backups are about 2 Gigs, so I could just do them as daily
full backups.|||Yeah, for only 2 GB do daily full backups including daily backups of your
system databases.
Hope this helps,
Ben Nevarez
"TJ" wrote:
> ok, thanks
> Yeah, the backups are about 2 Gigs, so I could just do them as daily
> full backups.
>|||... and, of course, carefully consider whether you also want to do more frequent transaction log
backups. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ben Nevarez" <bnevarez@.no.spam.please.sunamerica.com> wrote in message
news:CE066399-68A6-469E-BBCC-2792BF430D85@.microsoft.com...
> Yeah, for only 2 GB do daily full backups including daily backups of your
> system databases.
> Hope this helps,
> Ben Nevarez
>
>
> "TJ" wrote:
>> ok, thanks
>> Yeah, the backups are about 2 Gigs, so I could just do them as daily
>> full backups.

Backups with Maintenance Plans

Hi
I am new to database administration, and I am considering my options
for backups. We are using SQL Server 2005 Standard.
I have done some reading and have determined the right backup scheme
for us is a weekly complete Simple backup with daily Differential
backups.
I would like to set this up with a Maintenance Plan. How do I do this?
- do I set up two Maintenance Plans, one with the weekly backup and
one with the differentials?
- or do I do this with one Plan?
- or is this not possible with Maintenance Plans, in which case I
should just schedule an agent with SQL scripts?
thanks,
TJ
Hi,
You can create a Maintenance Plan for the weekly full backups and another
one for the daily differential backups.
Also, if your databases are smaller than, let us say, 100 or 200 GB perhaps
you can try daily full backups, depending on your backup window.
Hope this helps,
Ben Nevarez
"TJ" wrote:

> Hi
> I am new to database administration, and I am considering my options
> for backups. We are using SQL Server 2005 Standard.
> I have done some reading and have determined the right backup scheme
> for us is a weekly complete Simple backup with daily Differential
> backups.
> I would like to set this up with a Maintenance Plan. How do I do this?
> - do I set up two Maintenance Plans, one with the weekly backup and
> one with the differentials?
> - or do I do this with one Plan?
> - or is this not possible with Maintenance Plans, in which case I
> should just schedule an agent with SQL scripts?
> thanks,
> TJ
>
|||ok, thanks
Yeah, the backups are about 2 Gigs, so I could just do them as daily
full backups.
|||Yeah, for only 2 GB do daily full backups including daily backups of your
system databases.
Hope this helps,
Ben Nevarez
"TJ" wrote:

> ok, thanks
> Yeah, the backups are about 2 Gigs, so I could just do them as daily
> full backups.
>

Wednesday, March 7, 2012

Backups failing

I am running SQL-2000 Standard (SP3) and have created a backup job a while
back to back up several databases, and a seperate job to backup transaction
logs. 2 out of the 3 databases are being backed up and the transaction logs
are backing up, but our largest database (almost 5GB) is failing on the
backup. Where can I look to see why it is failing?
How do you run these jobs, and what types are they of. Maint Wiz? SQL Server Agent jobs, TSQL or
CmdExec? Etc...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:%23v8hVlDvEHA.3976@.TK2MSFTNGP09.phx.gbl...
>I am running SQL-2000 Standard (SP3) and have created a backup job a while
> back to back up several databases, and a seperate job to backup transaction
> logs. 2 out of the 3 databases are being backed up and the transaction logs
> are backing up, but our largest database (almost 5GB) is failing on the
> backup. Where can I look to see why it is failing?
|||Tibor Karaszi wrote:

> How do you run these jobs, and what types are they of. Maint Wiz? SQL
> Server Agent jobs, TSQL or CmdExec? Etc...
>
They were created using the Maintenance Wizard and scheduled to run nightly.
|||You may need to look at both the job history (make sure to view step
details) and the MP history.
Andrew J. Kelly SQL MVP
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:%23v8hVlDvEHA.3976@.TK2MSFTNGP09.phx.gbl...
>I am running SQL-2000 Standard (SP3) and have created a backup job a while
> back to back up several databases, and a seperate job to backup
> transaction
> logs. 2 out of the 3 databases are being backed up and the transaction
> logs
> are backing up, but our largest database (almost 5GB) is failing on the
> backup. Where can I look to see why it is failing?
|||In addition to Andrew's answer, I suggest you specify a report file in Main Wiz and look for error
messages in there.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:estbZJEvEHA.3424@.TK2MSFTNGP09.phx.gbl...
> Tibor Karaszi wrote:
>
> They were created using the Maintenance Wizard and scheduled to run nightly.

Backups failing

I am running SQL-2000 Standard (SP3) and have created a backup job a while
back to back up several databases, and a seperate job to backup transaction
logs. 2 out of the 3 databases are being backed up and the transaction logs
are backing up, but our largest database (almost 5GB) is failing on the
backup. Where can I look to see why it is failing?How do you run these jobs, and what types are they of. Maint Wiz? SQL Server Agent jobs, TSQL or
CmdExec? Etc...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:%23v8hVlDvEHA.3976@.TK2MSFTNGP09.phx.gbl...
>I am running SQL-2000 Standard (SP3) and have created a backup job a while
> back to back up several databases, and a seperate job to backup transaction
> logs. 2 out of the 3 databases are being backed up and the transaction logs
> are backing up, but our largest database (almost 5GB) is failing on the
> backup. Where can I look to see why it is failing?|||Tibor Karaszi wrote:
> How do you run these jobs, and what types are they of. Maint Wiz? SQL
> Server Agent jobs, TSQL or CmdExec? Etc...
>
They were created using the Maintenance Wizard and scheduled to run nightly.|||You may need to look at both the job history (make sure to view step
details) and the MP history.
--
Andrew J. Kelly SQL MVP
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:%23v8hVlDvEHA.3976@.TK2MSFTNGP09.phx.gbl...
>I am running SQL-2000 Standard (SP3) and have created a backup job a while
> back to back up several databases, and a seperate job to backup
> transaction
> logs. 2 out of the 3 databases are being backed up and the transaction
> logs
> are backing up, but our largest database (almost 5GB) is failing on the
> backup. Where can I look to see why it is failing?|||In addition to Andrew's answer, I suggest you specify a report file in Main Wiz and look for error
messages in there.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:estbZJEvEHA.3424@.TK2MSFTNGP09.phx.gbl...
> Tibor Karaszi wrote:
>> How do you run these jobs, and what types are they of. Maint Wiz? SQL
>> Server Agent jobs, TSQL or CmdExec? Etc...
>
> They were created using the Maintenance Wizard and scheduled to run nightly.

Backups failing

I am running SQL-2000 Standard (SP3) and have created a backup job a while
back to back up several databases, and a seperate job to backup transaction
logs. 2 out of the 3 databases are being backed up and the transaction logs
are backing up, but our largest database (almost 5GB) is failing on the
backup. Where can I look to see why it is failing?How do you run these jobs, and what types are they of. Maint Wiz? SQL Server
Agent jobs, TSQL or
CmdExec? Etc...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:%23v8hVlDvEHA.3976@.TK2MSFTNGP09.phx.gbl...
>I am running SQL-2000 Standard (SP3) and have created a backup job a while
> back to back up several databases, and a seperate job to backup transactio
n
> logs. 2 out of the 3 databases are being backed up and the transaction log
s
> are backing up, but our largest database (almost 5GB) is failing on the
> backup. Where can I look to see why it is failing?|||Tibor Karaszi wrote:

> How do you run these jobs, and what types are they of. Maint Wiz? SQL
> Server Agent jobs, TSQL or CmdExec? Etc...
>
They were created using the Maintenance Wizard and scheduled to run nightly.|||You may need to look at both the job history (make sure to view step
details) and the MP history.
Andrew J. Kelly SQL MVP
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:%23v8hVlDvEHA.3976@.TK2MSFTNGP09.phx.gbl...
>I am running SQL-2000 Standard (SP3) and have created a backup job a while
> back to back up several databases, and a seperate job to backup
> transaction
> logs. 2 out of the 3 databases are being backed up and the transaction
> logs
> are backing up, but our largest database (almost 5GB) is failing on the
> backup. Where can I look to see why it is failing?|||In addition to Andrew's answer, I suggest you specify a report file in Main
Wiz and look for error
messages in there.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:estbZJEvEHA.3424@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Tibor Karaszi wrote:
>
>
> They were created using the Maintenance Wizard and scheduled to run nightly.[/vbco
l]

Thursday, February 16, 2012

Backup Wizard 2005 Standard

I have a new installation of SQL 2005 standard and I cannot create an
automatic backup. When I launch the wizard I get an error " Failed to
retrieve data for this request. (Microsoft.Sqlserver.SmoEnum) Invalid column
name 'msx_job_id'. (Microsoft SQL Server, Error: 207). I click okay and I ca
n
then create my backup job, but upon completion I get these 2 error:
Invalid column name 'from_msx'.
Invalid column name 'has_target'.
I have to manually launch the backups each night and that work fine. I
previously was using Sql 2000 and the backup jobs ran without any problems.On Apr 19, 1:40 pm, Todd <T...@.discussions.microsoft.com> wrote:[vbcol=seagreen]
> I have a new installation of SQL 2005 standard and I cannot create an
> automatic backup. When I launch the wizard I get an error " Failed to
> retrieve data for this request. (Microsoft.Sqlserver.SmoEnum) Invalid colu
mn
> name 'msx_job_id'. (Microsoft SQL Server, Error: 207). I click okay and I
can
> then create my backup job, but upon completion I get these 2 error:
> Invalid column name 'from_msx'.
> Invalid column name 'has_target'.
> I have to manually launch the backups each night and that work fine. I
> previously was using Sql 2000 and the backup jobs ran without any problems.[/vbcol
]
Is this a server you upgraded to 2005 was a target server and prior to
upgrade did the server have master server?|||No this is a new Server not an upgrade. I moved the 2000 db over to this
server.
"Bulent" wrote:

> On Apr 19, 1:40 pm, Todd <T...@.discussions.microsoft.com> wrote:
> Is this a server you upgraded to 2005 was a target server and prior to
> upgrade did the server have master server?
>

Backup Wizard 2005 Standard

I have a new installation of SQL 2005 standard and I cannot create an
automatic backup. When I launch the wizard I get an error " Failed to
retrieve data for this request. (Microsoft.Sqlserver.SmoEnum) Invalid column
name 'msx_job_id'. (Microsoft SQL Server, Error: 207). I click okay and I can
then create my backup job, but upon completion I get these 2 error:
Invalid column name 'from_msx'.
Invalid column name 'has_target'.
I have to manually launch the backups each night and that work fine. I
previously was using Sql 2000 and the backup jobs ran without any problems.On Apr 19, 1:40 pm, Todd <T...@.discussions.microsoft.com> wrote:
> I have a new installation of SQL 2005 standard and I cannot create an
> automatic backup. When I launch the wizard I get an error " Failed to
> retrieve data for this request. (Microsoft.Sqlserver.SmoEnum) Invalid column
> name 'msx_job_id'. (Microsoft SQL Server, Error: 207). I click okay and I can
> then create my backup job, but upon completion I get these 2 error:
> Invalid column name 'from_msx'.
> Invalid column name 'has_target'.
> I have to manually launch the backups each night and that work fine. I
> previously was using Sql 2000 and the backup jobs ran without any problems.
Is this a server you upgraded to 2005 was a target server and prior to
upgrade did the server have master server?|||No this is a new Server not an upgrade. I moved the 2000 db over to this
server.
"Bulent" wrote:
> On Apr 19, 1:40 pm, Todd <T...@.discussions.microsoft.com> wrote:
> > I have a new installation of SQL 2005 standard and I cannot create an
> > automatic backup. When I launch the wizard I get an error " Failed to
> > retrieve data for this request. (Microsoft.Sqlserver.SmoEnum) Invalid column
> > name 'msx_job_id'. (Microsoft SQL Server, Error: 207). I click okay and I can
> > then create my backup job, but upon completion I get these 2 error:
> > Invalid column name 'from_msx'.
> > Invalid column name 'has_target'.
> >
> > I have to manually launch the backups each night and that work fine. I
> > previously was using Sql 2000 and the backup jobs ran without any problems.
> Is this a server you upgraded to 2005 was a target server and prior to
> upgrade did the server have master server?
>

Backup Wizard 2005 Standard

I have a new installation of SQL 2005 standard and I cannot create an
automatic backup. When I launch the wizard I get an error " Failed to
retrieve data for this request. (Microsoft.Sqlserver.SmoEnum) Invalid column
name 'msx_job_id'. (Microsoft SQL Server, Error: 207). I click okay and I can
then create my backup job, but upon completion I get these 2 error:
Invalid column name 'from_msx'.
Invalid column name 'has_target'.
I have to manually launch the backups each night and that work fine. I
previously was using Sql 2000 and the backup jobs ran without any problems.
On Apr 19, 1:40 pm, Todd <T...@.discussions.microsoft.com> wrote:
> I have a new installation of SQL 2005 standard and I cannot create an
> automatic backup. When I launch the wizard I get an error " Failed to
> retrieve data for this request. (Microsoft.Sqlserver.SmoEnum) Invalid column
> name 'msx_job_id'. (Microsoft SQL Server, Error: 207). I click okay and I can
> then create my backup job, but upon completion I get these 2 error:
> Invalid column name 'from_msx'.
> Invalid column name 'has_target'.
> I have to manually launch the backups each night and that work fine. I
> previously was using Sql 2000 and the backup jobs ran without any problems.
Is this a server you upgraded to 2005 was a target server and prior to
upgrade did the server have master server?
|||No this is a new Server not an upgrade. I moved the 2000 db over to this
server.
"Bulent" wrote:

> On Apr 19, 1:40 pm, Todd <T...@.discussions.microsoft.com> wrote:
> Is this a server you upgraded to 2005 was a target server and prior to
> upgrade did the server have master server?
>

Friday, February 10, 2012

Backup to network drive using Workgroup/Standard.

I am using SQL Server 2005 Express Edition. I am planning on upgrading to either Workgroup or Standard edition. While working with Express Edition I did find out that this version does not support backup to a network drive.
My question is:

Is it possible to backup directly to a network drive using a Workgroup/ Standard edition of SQL Server rather than backing up to a local drive and then 'copy and paste' to a network drive like the Express Edition.My other question is :
Given a database limit of 50GB, which one of the editions, Workgroup or Standard, will be appropriate for use.Thank you for your time and patience.
Regards
Berly Sam

You cannot backup to a network share with any edition of SQL Server.

SQL Server Backup will only used locally attached drives, or NAS/SAN LUNs. You can either backup locally, and then move the file to a network share (both tasks can be automated with SQL Agent -not included with SQL Express), or Check out the several third party backup tools. (Idera, Red-Gate, to name a couple.)

Workgroup-Standard-Enterprise, which is 'best'. It depends upon the functionality that you require. With a database of that size, you are definitely between the Standard and Enterprise Editions (in my opinion). You may wish to check out the functionality differences at this site.

|||Thats not exactly true, you cannot see the backup media in the SQL Server dialog as it only displays local fixed drives, but you can specify a UNC share within the dialog textbox or within the script. Depending on the situation you should rather consider using a local /SAN / NAS backup first and then copy it to a network share if needed.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Jens,

I consider it a gentle ‘challenge’ for me to give more consideration to why I responded as I did. And I appreciate that.

As I contemplate why I thought so, all I can remember is ever since 6.5, I have always taught to backup locally and xcopy to a net share. I can only imagine that was because of the speed issues of what used to be slower networks, as well as the persistence and permissions issues related to mapped drives.

And I now realize that I have not reconsidered or changed that practice in the intervening years.

I’m glad that you challenged me, now I have tested and affirmed that a backup to a UNC works just fine. But I doubt that I will change my practice of Backing up locally and using xcopy to move the backup file to a network resource -the BACKUP won't fail because of any network issues.

Regards,

- Arnie Rowland

Thursday, March 22, 2012

Barcode font not exporting to PDF

Barcode doesn't print from reports server

Barcode doesn't print from reports server

Barcode doesn't print from reports server

Thursday, March 8, 2012

Backups...daily

Backups...daily

Backups...daily

Backups with Maintenance Plans

Backups with Maintenance Plans

Wednesday, March 7, 2012

Backups failing

Backups failing

Backups failing

Thursday, February 16, 2012

Backup Wizard 2005 Standard

Backup Wizard 2005 Standard

Backup Wizard 2005 Standard

Friday, February 10, 2012

Backup to network drive using Workgroup/Standard.

Backup to Network Drive

Blog Archive

About Me