Showing posts with label available. Show all posts
Showing posts with label available. Show all posts

Wednesday, March 7, 2012

another backup question

why are 'transaction log' and 'file and file group' dimmed (not available)
on the general tab of the backup window? (right-click on database, all
tasks, backup database)
I am backing up to a file device and need to set a schedule of 1 daily full
backup and backup of the transaction logs every 1/2 hour.
any help is appreciated.
Because the database is in simple recovery mode.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"djc" <noone@.nowhere.com> wrote in message news:ucbsl59UEHA.3420@.TK2MSFTNGP12.phx.gbl...
> why are 'transaction log' and 'file and file group' dimmed (not available)
> on the general tab of the backup window? (right-click on database, all
> tasks, backup database)
> I am backing up to a file device and need to set a schedule of 1 daily full
> backup and backup of the transaction logs every 1/2 hour.
> any help is appreciated.
>
|||Thank you!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uWjcUB%23UEHA.1048@.tk2msftngp13.phx.gbl...
> Because the database is in simple recovery mode.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "djc" <noone@.nowhere.com> wrote in message
news:ucbsl59UEHA.3420@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
available)[vbcol=seagreen]
full
>

another backup question

why are 'transaction log' and 'file and file group' dimmed (not available)
on the general tab of the backup window? (right-click on database, all
tasks, backup database)
I am backing up to a file device and need to set a schedule of 1 daily full
backup and backup of the transaction logs every 1/2 hour.
any help is appreciated.Because the database is in simple recovery mode.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"djc" <noone@.nowhere.com> wrote in message news:ucbsl59UEHA.3420@.TK2MSFTNGP12.phx.gbl...
> why are 'transaction log' and 'file and file group' dimmed (not available)
> on the general tab of the backup window? (right-click on database, all
> tasks, backup database)
> I am backing up to a file device and need to set a schedule of 1 daily full
> backup and backup of the transaction logs every 1/2 hour.
> any help is appreciated.
>|||Thank you!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uWjcUB%23UEHA.1048@.tk2msftngp13.phx.gbl...
> Because the database is in simple recovery mode.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "djc" <noone@.nowhere.com> wrote in message
news:ucbsl59UEHA.3420@.TK2MSFTNGP12.phx.gbl...
> > why are 'transaction log' and 'file and file group' dimmed (not
available)
> > on the general tab of the backup window? (right-click on database, all
> > tasks, backup database)
> >
> > I am backing up to a file device and need to set a schedule of 1 daily
full
> > backup and backup of the transaction logs every 1/2 hour.
> >
> > any help is appreciated.
> >
> >
>

Saturday, February 25, 2012

Announcement: MSDN Article "Integrating Analysis Services with Reporting Services" Availab

The following whitepaper is now available on MSDN:
"Integrating Analysis Services with Reporting Services" at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp.
Summary: Create a compelling solution for your customer that defines and
manages great-looking Analysis Services reports, and quickly answers
analytical questions to improve traditional reporting scenarios. (33 printed
pages)
The following topics are covered:
Introduction
Developing OLAP Reports Using Analysis Services 2000 and Reporting Services
Datasets and Data Regions in SQL Server 2000 Reporting Services
Defining a Data Source
Building a Static Report with Analysis Services Data
Adding Parameters to an OLAP Report
Adding Additional Interactivity to Reports
Analysis Services Actions
Conclusion
--
Sean Boon
Microsoft Office BI
This posting is provided "AS IS" with no warranties, and confers no rights.In news:OLSM2s7VEHA.1888@.TK2MSFTNGP11.phx.gbl,
Sean Boon [MS] <seanboon@.online.microsoft.com> typed:
> The following whitepaper is now available on MSDN:
> "Integrating Analysis Services with Reporting Services" at
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/htm
l/olapasandrs.asp.
> Summary: Create a compelling solution for your customer
> that defines and
> manages great-looking Analysis Services reports, and
> quickly answers
> analytical questions to improve traditional reporting
> scenarios. (33 printed
> pages)
> The following topics are covered:
> Introduction
> Developing OLAP Reports Using Analysis Services 2000 and
> Reporting Services
> Datasets and Data Regions in SQL Server 2000 Reporting
> Services
> Defining a Data Source
> Building a Static Report with Analysis Services Data
> Adding Parameters to an OLAP Report
> Adding Additional Interactivity to Reports
> Analysis Services Actions
> Conclusion
Am I missing something or does the sample code require anything other than
VS 2003 and RS? I wonder about xxx.RDL.XML, which is not recognized to be a
valid report file by ReportDesigner.
Sorry if I'm too stupid to catch the things.
r.

Friday, February 24, 2012

ANN: Updated version of SQL Server 2005 Books Online is available for download

The September 2007 update to SQL Server 2005 Books Online (English version)
is now available for download at
http://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f&DisplayLang=en.
It is also offered as an Optional update via Microsoft Update.
See the topic "New and Updated Books Online"
(ms-help://sql90/sqlwhtn9/html/0f2f37d8-fc81-40c5-9976-cab8bd0b44e9.htm) for
links to the new and revised topics.
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
On Dec 1, 5:53 am, "Gail Erickson [MS]" <ga...@.online.microsoft.com>
wrote:
> The September 2007 update to SQL Server 2005 Books Online (English version)
> is now available for download athttp://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00d...
> It is also offered as an Optional update via Microsoft Update.
> See the topic "New and Updated Books Online"
> (ms-help://sql90/sqlwhtn9/html/0f2f37d8-fc81-40c5-9976-cab8bd0b44e9.htm) for
> links to the new and revised topics.
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> Download the latest version of Books Online fromhttp://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
Thanks for the updation

ANN: Updated version of SQL Server 2005 Books Online is available for download

The September 2007 update to SQL Server 2005 Books Online (English version)
is now available for download at
http://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f&DisplayLang=en.
It is also offered as an Optional update via Microsoft Update.
See the topic "New and Updated Books Online"
(ms-help://sql90/sqlwhtn9/html/0f2f37d8-fc81-40c5-9976-cab8bd0b44e9.htm) for
links to the new and revised topics.
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://technet.microsoft.com/en-us/sqlserver/bb428874.aspxOn Dec 1, 5:53 am, "Gail Erickson [MS]" <ga...@.online.microsoft.com>
wrote:
> The September 2007 update to SQL Server 2005 Books Online (English version)
> is now available for download athttp://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00d...
> It is also offered as an Optional update via Microsoft Update.
> See the topic "New and Updated Books Online"
> (ms-help://sql90/sqlwhtn9/html/0f2f37d8-fc81-40c5-9976-cab8bd0b44e9.htm) for
> links to the new and revised topics.
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> Download the latest version of Books Online fromhttp://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
Thanks for the updation

ANN: 25% discount on Upscene products during our spring sale!

Upscene Productions announces a Spring Sale with 25% discount on all
database developer tools!
Currently available from Upscene Productions:
Database Workbench
A multi-database engine development IDE, currently supporting Microsoft SQL
Server, Oracle, InterBase, Firebird, MySQL and NexusDB.
IB LogManager Suite
An auditing/logging suite for InterBase & Firebird.
MSSQL LogManager Suite
An auditing/logging suite for Microsoft SQL Server.
ADS LogManager Suite
An auditing/logging suite for Advantage Database.
NDB LogManager Suite
An auditing/logging suite for NexusDB.
Advanced Data Generator
A comprehensive test data generator tool with support for ADO/ODBC
connectivity or specialized versions for InterBase, Firebird or MySQL.
InterXpress for Firebird
A dbExpress driver for Firebird supporting Delphi 6 - 2006 and Kylix 3.
When purchasing, enter coupon code SPRINGSALE2006 to get your discount.
More information about Upscene Productions products at
http://www.upscene.comModerator please delete this spam.
"Martijn Tonies" wrote:
> Upscene Productions announces a Spring Sale with 25% discount on all
> database developer tools!
> Currently available from Upscene Productions:
> Database Workbench
> A multi-database engine development IDE, currently supporting Microsoft SQL
> Server, Oracle, InterBase, Firebird, MySQL and NexusDB.
> IB LogManager Suite
> An auditing/logging suite for InterBase & Firebird.
> MSSQL LogManager Suite
> An auditing/logging suite for Microsoft SQL Server.
> ADS LogManager Suite
> An auditing/logging suite for Advantage Database.
> NDB LogManager Suite
> An auditing/logging suite for NexusDB.
> Advanced Data Generator
> A comprehensive test data generator tool with support for ADO/ODBC
> connectivity or specialized versions for InterBase, Firebird or MySQL.
> InterXpress for Firebird
> A dbExpress driver for Firebird supporting Delphi 6 - 2006 and Kylix 3.
> When purchasing, enter coupon code SPRINGSALE2006 to get your discount.
> More information about Upscene Productions products at
> http://www.upscene.com
>
>
>
>

ANN: 25% discount on Upscene products during our spring sale!

Upscene Productions announces a Spring Sale with 25% discount on all
database developer tools!
Currently available from Upscene Productions:
Database Workbench
A multi-database engine development IDE, currently supporting Microsoft SQL
Server, Oracle, InterBase, Firebird, mysql and NexusDB.
IB LogManager Suite
An auditing/logging suite for InterBase & Firebird.
MSSQL LogManager Suite
An auditing/logging suite for Microsoft SQL Server.
ADS LogManager Suite
An auditing/logging suite for Advantage Database.
NDB LogManager Suite
An auditing/logging suite for NexusDB.
Advanced Data Generator
A comprehensive test data generator tool with support for ADO/ODBC
connectivity or specialized versions for InterBase, Firebird or MySQL.
InterXpress for Firebird
A dbExpress driver for Firebird supporting Delphi 6 - 2006 and Kylix 3.
When purchasing, enter coupon code SPRINGSALE2006 to get your discount.
More information about Upscene Productions products at
http://www.upscene.comModerator please delete this spam.
"Martijn Tonies" wrote:

> Upscene Productions announces a Spring Sale with 25% discount on all
> database developer tools!
> Currently available from Upscene Productions:
> Database Workbench
> A multi-database engine development IDE, currently supporting Microsoft SQ
L
> Server, Oracle, InterBase, Firebird, mysql and NexusDB.
> IB LogManager Suite
> An auditing/logging suite for InterBase & Firebird.
> MSSQL LogManager Suite
> An auditing/logging suite for Microsoft SQL Server.
> ADS LogManager Suite
> An auditing/logging suite for Advantage Database.
> NDB LogManager Suite
> An auditing/logging suite for NexusDB.
> Advanced Data Generator
> A comprehensive test data generator tool with support for ADO/ODBC
> connectivity or specialized versions for InterBase, Firebird or MySQL.
> InterXpress for Firebird
> A dbExpress driver for Firebird supporting Delphi 6 - 2006 and Kylix 3.
> When purchasing, enter coupon code SPRINGSALE2006 to get your discount.
> More information about Upscene Productions products at
> http://www.upscene.com
>
>
>
>|||Moderator please delete this spam.
"Martijn Tonies" wrote:

> Upscene Productions announces a Spring Sale with 25% discount on all
> database developer tools!
> Currently available from Upscene Productions:
> Database Workbench
> A multi-database engine development IDE, currently supporting Microsoft SQ
L
> Server, Oracle, InterBase, Firebird, mysql and NexusDB.
> IB LogManager Suite
> An auditing/logging suite for InterBase & Firebird.
> MSSQL LogManager Suite
> An auditing/logging suite for Microsoft SQL Server.
> ADS LogManager Suite
> An auditing/logging suite for Advantage Database.
> NDB LogManager Suite
> An auditing/logging suite for NexusDB.
> Advanced Data Generator
> A comprehensive test data generator tool with support for ADO/ODBC
> connectivity or specialized versions for InterBase, Firebird or MySQL.
> InterXpress for Firebird
> A dbExpress driver for Firebird supporting Delphi 6 - 2006 and Kylix 3.
> When purchasing, enter coupon code SPRINGSALE2006 to get your discount.
> More information about Upscene Productions products at
> http://www.upscene.com
>
>
>
>

Angry about Reporting Services

I have seen the odd thread on here that just mentions in passing that data-driven subscriptions are only available on the SQL 2005 Enterprise edition. Does no-one else but me think that this is absolutely disgraceful? We bought SQL Server Standard for our 2 processor server and it cost just under £8,000. The only reason we would have to buy Enterprise is for the data-driven subscriptions in RS and that would cost us £33,000. When the beta of RS came out, it had data-driven subscriptions at all levels. When RS 2000 came out, we could easily get a legitimate copy of RS 2000 Enterprise from Microsoft and have the same functionality. Now we have to pay £25,000 for the privilege or hand-code the whole thing. I repeat; this is an absolutely disgraceful piece of profiteering from Microsoft. Do they really think that data-driven subscriptions are only of value to people using the Enterprise edition?

This forum is intended for assistance and bug reporting with RS. Call customer support if you're that upset about the product. What do you expect them to do? Give it to you for free now because you're angry?

I think it is disgraceful that you would use an open forum to vent about a product that you purchased which is documented as to what it includes and what it does not include.

|||

I think it's disgraceful that a product which was in all versions of the beta and freely available in SQL 2000, now costs me £25,000 in SQL 2005. Don't you?

As I believe this forum is read by Microsoft developers, maybe I thought they could give me a rational response. If you know of a place where I can get a better response, or where I ought to post this, please let me know. It is not my intention to upset anyone on the forum, just to let Microsoft know how I feel about their product.

|||

Leaving strong words aside, I think your complaint is not unreasonble and it is good to provide this kind of feedback. Crossing the enterprise hefty price tag is not an easy sell especially for vendors. I tend to agree with you we are suffering from an "enterprise" identity crisis and thus the meaning of enerprise should be better scoped out. IMO, enterprise editions should differ only in the areas of scalability and to some extend extensibility in order to meet high loads and more involved integration requirements of large companies. Following this line of thought, I'd say that web farm deployment and partitioning are definately enterprise-level features while features like data-driven subscriptions and semi-additive measures (SSAS) are probably not.

From BOL: "Enterprise Edition scales to the performance levels required to support the largest enterprise online transaction processing (OLTP), highly complex data analysis, data warehousing systems, and Web sites. Enterprise Edition’s comprehensive business intelligence and analytics capabilities and its high availability features such as failover clustering allow it to handle the most mission critical enterprise workloads. Enterprise Edition is the most comprehensive edition of SQL Server and is ideal for the largest organizations and the most complex requirements."

Thursday, February 9, 2012

Analysis Services 2005 Performance Guide goes live!

The much anticipated and eagerly awaited Analysis Services 2005 Performance Guide has been released and is available on the Microsoft download site at: http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Edward,

I haven't really gotten a chance to dig into the guide yet, but kudos to the entire team that contributed to it! Just glancing at the TOC, it looks to be an excellent guide and a great read for all of us!!

Dave Fackler

|||Great - now sent directly to the printer :-)|||Wow, thank you guys!|||Reading it now. Thanks!|||

Hi Edward,

This is really exiciting,

This is one thing that was missing from the start.

Regards

Vijay R

|||Having just finished reading the SSAS 2005 Performance Guide in preparation for a large incoming BI project, I consider this guide to be technically indispensable as well as exceptionally readable -- a rare combo! Lastly, it reinforces the sophistication of AS 2005. Well done to the author and subject matter experts!|||

I noticed in the document that it applies to Sql Server 2005 - SP2.

When is SP2 going to be released?

There is a lot of great information in the guide that I am sure applies to SP1 as well, but what in it is SP2 specific?

Thanks,

Wino.

|||

You will see SP2 release pretty soon :)

Meantime you can try to install CTP of SP2 from http://www.microsoft.com/sql/ctp.mspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||What a wonderful document. I have been craving something like this ever since getting started with Analysis Services. This is better than any book / articles I have read about the "guts" of AS. Thank you so much!

Analysis Services 2005 Performance Guide goes live!

The much anticipated and eagerly awaited Analysis Services 2005 Performance Guide has been released and is available on the Microsoft download site at: http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Edward,

I haven't really gotten a chance to dig into the guide yet, but kudos to the entire team that contributed to it! Just glancing at the TOC, it looks to be an excellent guide and a great read for all of us!!

Dave Fackler

|||Great - now sent directly to the printer :-)|||Wow, thank you guys!|||Reading it now. Thanks!|||

Hi Edward,

This is really exiciting,

This is one thing that was missing from the start.

Regards

Vijay R

|||Having just finished reading the SSAS 2005 Performance Guide in preparation for a large incoming BI project, I consider this guide to be technically indispensable as well as exceptionally readable -- a rare combo! Lastly, it reinforces the sophistication of AS 2005. Well done to the author and subject matter experts!|||

I noticed in the document that it applies to Sql Server 2005 - SP2.

When is SP2 going to be released?

There is a lot of great information in the guide that I am sure applies to SP1 as well, but what in it is SP2 specific?

Thanks,

Wino.

|||

You will see SP2 release pretty soon :)

Meantime you can try to install CTP of SP2 from http://www.microsoft.com/sql/ctp.mspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||What a wonderful document. I have been craving something like this ever since getting started with Analysis Services. This is better than any book / articles I have read about the "guts" of AS. Thank you so much!

Analysis Services 2005 Performance Guide goes live!

The much anticipated and eagerly awaited Analysis Services 2005 Performance Guide has been released and is available on the Microsoft download site at: http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Edward,

I haven't really gotten a chance to dig into the guide yet, but kudos to the entire team that contributed to it! Just glancing at the TOC, it looks to be an excellent guide and a great read for all of us!!

Dave Fackler

|||Great - now sent directly to the printer :-)|||Wow, thank you guys!|||Reading it now. Thanks!|||

Hi Edward,

This is really exiciting,

This is one thing that was missing from the start.

Regards

Vijay R

|||Having just finished reading the SSAS 2005 Performance Guide in preparation for a large incoming BI project, I consider this guide to be technically indispensable as well as exceptionally readable -- a rare combo! Lastly, it reinforces the sophistication of AS 2005. Well done to the author and subject matter experts!|||

I noticed in the document that it applies to Sql Server 2005 - SP2.

When is SP2 going to be released?

There is a lot of great information in the guide that I am sure applies to SP1 as well, but what in it is SP2 specific?

Thanks,

Wino.

|||

You will see SP2 release pretty soon :)

Meantime you can try to install CTP of SP2 from http://www.microsoft.com/sql/ctp.mspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||What a wonderful document. I have been craving something like this ever since getting started with Analysis Services. This is better than any book / articles I have read about the "guts" of AS. Thank you so much!