Basic question

I've instaled M Visual Web Developer studio 2005 ee and SQL 2005.
Service is working, but i can't connect my project with serwer. ASP configuration tool(security) can't connect. Error message doesn't show any reason.
Server menager can connect normally.
Please help
what is the error message?sql

Basic question

I've instaled M Visual Web Developer studio 2005 ee and SQL 2005.
Service is working, but i can't connect my project with serwer. ASP configuration tool(security) can't connect. Error message doesn't show any reason.
Server menager can connect normally.
Please help
what is the error message?

Basic Functionality Questions

We've been trying to implement Reporting Services in our web application. We've run into 2 issues that I'd like to verify:

First, HTML rendering. In our application we provide an HTML Editor for formatting. The formatting does not render in the reporting services. I understand that's a known issue with no work around and no timeframe for resolution. Is that correct?

Second issue comes with tying is the Reporting Services together with our ASP.NET code. Do any of the Reporting Services controls allow you to bind to classes that support the IList Interface?

Thanks,

Frank

1) RS text box control does not render HTML. It supports standard formatting which applies to the entire contents of the textbox rather than individual bits of text as in a rich text box control.

2) RS reports are rendered based on the report definition and do not support binding custom datasets at runtime through the IList interface.

sql

baffled .. no data returned to web browser

Hi.
I have a parameter driven report that has been built and deployed
succesfully with no errors.
After execution of the report I am just left with the format of my
report in my web browser i.e. no data is displayed.
However ...when I run the exact same SP from query analyzer I receive
the correct result set.
In the executionlog table the executioon of the report is marked as
successfull and that a certain amount of bytes have been returned to
the client...
The amount of pages are also displayed indicating to me that it knows
it has received data'
Anyone have any ideas'
LCan you export the report from the web browser? And if so, how does it
look there?

bad excel performance / capacity question

a web application that i have recently deployed uses reporting services and exports data to excel reports with drill down options

i have reports that are being generated up to 5 MB and are not usable in excel (i.e. scrolling freezes, slow opening times, large file size)

the reason for this is the detail displayed for each record

each record has a drop down of approximatley 4-6 rows of detail

a report with 3000 lines will have those 4-6 rows of detail for each record

shouldn't excel be able to handle this?

the reports also take a long time to generate and i have had timeout issues, i was able to set the webservice that generates the reports to have no timeout to resolve this problem, my bigger concern is why excel performs so slowly and why the file size is so large

previously we ran these reports out of access, and instead of having the reporting services format, we displayed detail information across as columns and there was no performance issue with the same amount of data

the problems seems to be with out excel handles the (+) signs

Hi,

I also have this problem and it is a big problem according to my customers - I've contacted Microsoft via an incident.

The MS's answer was : the SSRS Excel renderer is the problem and it shall be solved in the next SQL Server version (completely rewritten). Not earlier, and there is no possibility to fix it now.

The only workaround I've found:

1. the main point is to open the exported excel file for the 1.time (you have simply to wait until it opens) and then copy-paste as values the whole sheet. save the file after this, the next time you open it you will see performance improvement.

2. maybe you can split the report into smaller parts - this means less data but more reports

3. you can modify the renderer by setting OMIT_FORMULAS to true in the renderer's config file (there will be no formulas exported, all is exported as values)

The only what really helps is the point 1.

Not only the (+) sign is the problem. I have a report exporting 7000 of rows in 20 columns and there is a problem too.

Hope this helps, if someone has more ideas please let me know, I would also appreciate it.

Jan

|||I would guess that you have a significant number of merged cells in your generated report, due to alignment issues in the RDL. Excel has known issues when loading a spreadsheet with many merge cells. The Excel Export in RS uses merged cells to maintain the layout defined in RDL, and if you have many rows, this can result in large numbers of merged cells.

Check out Chris's blog entry on merging cells and how to reduce them:
http://blogs.msdn.com/chrisbal/archive/2006/07/08/659545.aspx
|||

interesting...thanks for the answer

but there are no merged columns in my problematic excel file...and how is it possible that after copy-paste as values of the whole sheet becomes the opening and working with the excel file non-problematic...?

bad excel performance / capacity question

a web application that i have recently deployed uses reporting services and exports data to excel reports with drill down options

i have reports that are being generated up to 5 MB and are not usable in excel (i.e. scrolling freezes, slow opening times, large file size)

the reason for this is the detail displayed for each record

each record has a drop down of approximatley 4-6 rows of detail

a report with 3000 lines will have those 4-6 rows of detail for each record

shouldn't excel be able to handle this?

the reports also take a long time to generate and i have had timeout issues, i was able to set the webservice that generates the reports to have no timeout to resolve this problem, my bigger concern is why excel performs so slowly and why the file size is so large

previously we ran these reports out of access, and instead of having the reporting services format, we displayed detail information across as columns and there was no performance issue with the same amount of data

the problems seems to be with out excel handles the (+) signs

Hi,

I also have this problem and it is a big problem according to my customers - I've contacted Microsoft via an incident.

The MS's answer was : the SSRS Excel renderer is the problem and it shall be solved in the next SQL Server version (completely rewritten). Not earlier, and there is no possibility to fix it now.

The only workaround I've found:

1. the main point is to open the exported excel file for the 1.time (you have simply to wait until it opens) and then copy-paste as values the whole sheet. save the file after this, the next time you open it you will see performance improvement.

2. maybe you can split the report into smaller parts - this means less data but more reports

3. you can modify the renderer by setting OMIT_FORMULAS to true in the renderer's config file (there will be no formulas exported, all is exported as values)

The only what really helps is the point 1.

Not only the (+) sign is the problem. I have a report exporting 7000 of rows in 20 columns and there is a problem too.

Hope this helps, if someone has more ideas please let me know, I would also appreciate it.

Jan

|||I would guess that you have a significant number of merged cells in your generated report, due to alignment issues in the RDL. Excel has known issues when loading a spreadsheet with many merge cells. The Excel Export in RS uses merged cells to maintain the layout defined in RDL, and if you have many rows, this can result in large numbers of merged cells.

Check out Chris's blog entry on merging cells and how to reduce them:
http://blogs.msdn.com/chrisbal/archive/2006/07/08/659545.aspx|||

interesting...thanks for the answer

but there are no merged columns in my problematic excel file...and how is it possible that after copy-paste as values of the whole sheet becomes the opening and working with the excel file non-problematic...?

Bad Connection

I am getting the following error when I attempt to connect to SqlServer with the following connection string from my Web.config file:

<add name="LeanPathConnection" connectionString="Data Source=(local);Initial Catalog=VWOA1.DB;User Id=LeanPath;Password=jesus" />

I have made LeanPath a user at the Security level of the server. His default database is VWOA1.DB. I have given him db_owner rights. The following contains the exception detail I get. I don't see how he could NOT have a trusted SQL Server connection!!!!!!

System.Data.SqlClient.SqlException was unhandled by user code
Message="Login failed for user 'LeanPath'. The user is not associated with a trusted SQL Server connection."
Source=".Net SqlClient Data Provider"
ErrorCode=-2146232060
Class=14
LineNumber=65536
Number=18452
Procedure=""
Server="localhost"
State=1
StackTrace:
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at DbConnection.Open() in c:\Documents and Settings\sarogers\My Documents\Visual Studio 2005\Projects\VWOA\LRS\App_Code\DbConnection.cs:line 21
at MyBase.Execute() in c:\Documents and Settings\sarogers\My Documents\Visual Studio 2005\Projects\VWOA\LRS\App_Code\DbStoredProc.cs:line 63
at MyReturn.RetValParamInt(String ParamName) in c:\Documents and Settings\sarogers\My Documents\Visual Studio 2005\Projects\VWOA\LRS\App_Code\DbStoredProc.cs:line 328
at DbStoredProc.PER_Validate(String LoginName, String Password) in c:\Documents and Settings\sarogers\My Documents\Visual Studio 2005\Projects\VWOA\LRS\App_Code\DbStoredProc.cs:line 1215
at Login.btnLogin_Click(Object sender, EventArgs e) in c:\Documents and Settings\sarogers\My Documents\Visual Studio 2005\Projects\VWOA\LRS\Login.aspx.cs:line 43
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Hi,

you only have Windows Authentication enabled at your server, therefore the SQL Server tries to logon the user with WIndows Authentication. I guess that the LeanUser is a SQL Server User right ? Therefore you will have to use and enable SQL Server authentication first. See my Screencast on my site for more information how to switch from Windows Auth. to Mixed Auth. (SQL Server & Windows Auth).

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Backups/Restores of remote hosted SQL Server to Local?

Is there any way to backup a remote SQL Server that is on a hosted account to a local drive? We have a web hosted account that has a SQL Server that we do not have full admin rights on, just dbo access to the data and structure. We would like to be able to do backups and restores to our local development server if possible. Perhaps vis DTS or some similar means? WE cannot use the normal backup/restore as we do not have right to these fucntions nor can we access the servers local drives directly.You could certinly use DTS to transfer all objects from one server to another, presuming that the host allows SQL Server access through their firewall.|||

Yes the yallow that and support DTS packages.

Wha tis the best way to configure these to allow transferrring all data and objects? What needs to be setup first in terms of an empty database, user accounts, etc for this?

backups and restore DB in SQL EXPRESS 2005

can anyone explain me how can i make a DB backup in sql express 2005 ?
The sql express instance and my web aplication are running on the same server.
I need a script for directly execute it (and if possible also to restore the DB ) from my web aplication.

other question:
any idea how can i tell to sql express to do the backup automatically every day?

To backup SQL Server you either use a stored proc to do it or you use one of the best part of SQL Server called the backup and restore wizard to backup the database. To backup daily you need to schedule the backup with SQL Server Agent Job. To do all of the above you need the new Enterprise Manager called Management Studio but Express did not come with it so donwload the eval version from the link below it is good for 180 days install it as a named instance. Then right click at the top of the Management Studio and register the Express so you can use the Management Studio to do all of the above. Hope this helps.

http://www.microsoft.com/downloads/details.aspx?familyid=6931FA7F-C094-49A2-A050-2D07993566EC&displaylang=en

Backup/restore Databases remotely.

Hi i've tried a few remote administration tools including Microsofts own Web Data Administrator for SQL server... but none of them seem to do what is essential to me and that is backup/restore databases to a file.
Does anyone know of a free tool that can just backup/restore databases remotely. I dont really want to have to use export/import data as things like triggers get lost when using Microsoft Web data administrator.
A free web tool written in ASP.NET or ASP would be ideal. But PHP would also be fine.
Thanks
I don't understand . Why did you say that you can not
backup/restore to a file. As long as SQL server can
access that folder, it can backup/restore to/from that
folder.
>--Original Message--
>Hi i've tried a few remote administration tools
including Microsofts own Web Data Administrator for SQL
server... but none of them seem to do what is essential
to me and that is backup/restore databases to a file.
>Does anyone know of a free tool that can just
backup/restore databases remotely. I dont really want to
have to use export/import data as things like triggers
get lost when using Microsoft Web data administrator.
>A free web tool written in ASP.NET or ASP would be
ideal. But PHP would also be fine.
>Thanks
>.
>
|||SQL server itself can backup/restore yes. But the remote web admin tool cannot.. it can only import/export data which does not include things like triggers.
See this page:
http://www.databasejournal.com/featu...0894_3330301_2
And I quote:
"Database Administration Functions missing from Web Data Administration tool
- Can't create a database backup and restore a database "
|||The article also says:
Even though these are not provided with the tool, some of
these items can be performed by using the Query tool to
submit T-SQL code to perform these tasks.
You can do backups and restores through T-SQL. In many
cases, most of what any of the tools do can be done in
T-SQL.
-Sue
On Thu, 8 Apr 2004 12:46:05 -0700, "GregD"
<anonymous@.discussions.microsoft.com> wrote:

>SQL server itself can backup/restore yes. But the remote web admin tool cannot.. it can only import/export data which does not include things like triggers.
>See this page:
>http://www.databasejournal.com/featu...0894_3330301_2
>And I quote:
>"Database Administration Functions missing from Web Data Administration tool
>- Can't create a database backup and restore a database "
|||Hi Sue,
What would the syntax be for backup/restore in TSQL? Or do you have a link where I can find this out myself?
Thanks for your help.
|||No matter found it myself on MSDN:
BACKUP DATABASE DBNameGoesHere
TO DISK = 'C:\temp\Somefilename.bak'
WITH INIT
RESTORE DATABASE DBNameGoesHere
FROM DISK = 'C:\temp\Somefilename.bak'
WITH REPLACE
|||Books Online is available within the SQL Server program group (assuming =
that you have SQL Server installed). =20
Books Online can be downloaded separately if necessary:
http://www.microsoft.com/sql/downloads/default.asp
Here is the specific link to the BOL download:
http://www.microsoft.com/sql/techinf...2000/books.asp
--=20
Keith
"GregD" <anonymous@.discussions.microsoft.com> wrote in message =
news:FBB86780-E276-4A02-B618-A7360E899FDC@.microsoft.com...
> No matter found it myself on MSDN:
>=20
> BACKUP DATABASE DBNameGoesHere
> TO DISK =3D 'C:\temp\Somefilename.bak'
> WITH INIT
>=20
> RESTORE DATABASE DBNameGoesHere
> FROM DISK =3D 'C:\temp\Somefilename.bak'
> WITH REPLACE

Backup/restore Databases remotely.

Hi i've tried a few remote administration tools including Microsofts own Web Data Administrator for SQL server... but none of them seem to do what is essential to me and that is backup/restore databases to a file.
Does anyone know of a free tool that can just backup/restore databases remotely. I dont really want to have to use export/import data as things like triggers get lost when using Microsoft Web data administrator.
A free web tool written in ASP.NET or ASP would be ideal. But PHP would also be fine.
ThanksI don't understand . Why did you say that you can not
backup/restore to a file. As long as SQL server can
access that folder, it can backup/restore to/from that
folder.
>--Original Message--
>Hi i've tried a few remote administration tools
including Microsofts own Web Data Administrator for SQL
server... but none of them seem to do what is essential
to me and that is backup/restore databases to a file.
>Does anyone know of a free tool that can just
backup/restore databases remotely. I dont really want to
have to use export/import data as things like triggers
get lost when using Microsoft Web data administrator.
>A free web tool written in ASP.NET or ASP would be
ideal. But PHP would also be fine.
>Thanks
>.
>|||SQL server itself can backup/restore yes. But the remote web admin tool cannot.. it can only import/export data which does not include things like triggers.
See this page:
http://www.databasejournal.com/features/mssql/article.php/10894_3330301_2
And I quote:
"Database Administration Functions missing from Web Data Administration tool
- Can't create a database backup and restore a database "|||The article also says:
Even though these are not provided with the tool, some of
these items can be performed by using the Query tool to
submit T-SQL code to perform these tasks.
You can do backups and restores through T-SQL. In many
cases, most of what any of the tools do can be done in
T-SQL.
-Sue
On Thu, 8 Apr 2004 12:46:05 -0700, "GregD"
<anonymous@.discussions.microsoft.com> wrote:
>SQL server itself can backup/restore yes. But the remote web admin tool cannot.. it can only import/export data which does not include things like triggers.
>See this page:
>http://www.databasejournal.com/features/mssql/article.php/10894_3330301_2
>And I quote:
>"Database Administration Functions missing from Web Data Administration tool
>- Can't create a database backup and restore a database "|||Hi Sue
What would the syntax be for backup/restore in TSQL? Or do you have a link where I can find this out myself? :
Thanks for your help.|||No matter found it myself on MSDN
BACKUP DATABASE DBNameGoesHer
TO DISK = 'C:\temp\Somefilename.bak
WITH INI
RESTORE DATABASE DBNameGoesHer
FROM DISK = 'C:\temp\Somefilename.bak
WITH REPLACE|||Books Online is available within the SQL Server program group (assuming =that you have SQL Server installed).
Books Online can be downloaded separately if necessary:
http://www.microsoft.com/sql/downloads/default.asp
Here is the specific link to the BOL download:
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
-- Keith
"GregD" <anonymous@.discussions.microsoft.com> wrote in message =news:FBB86780-E276-4A02-B618-A7360E899FDC@.microsoft.com...
> No matter found it myself on MSDN:
> > BACKUP DATABASE DBNameGoesHere
> TO DISK =3D 'C:\temp\Somefilename.bak'
> WITH INIT
> > RESTORE DATABASE DBNameGoesHere
> FROM DISK =3D 'C:\temp\Somefilename.bak'
> WITH REPLACE

Backup/restore Databases remotely.

Hi i've tried a few remote administration tools including Microsofts own Web
Data Administrator for SQL server... but none of them seem to do what is es
sential to me and that is backup/restore databases to a file.
Does anyone know of a free tool that can just backup/restore databases remot
ely. I dont really want to have to use export/import data as things like tri
ggers get lost when using Microsoft Web data administrator.
A free web tool written in ASP.NET or ASP would be ideal. But php would also
be fine.
ThanksI don't understand . Why did you say that you can not
backup/restore to a file. As long as SQL server can
access that folder, it can backup/restore to/from that
folder.
>--Original Message--
>Hi i've tried a few remote administration tools
including Microsofts own Web Data Administrator for SQL
server... but none of them seem to do what is essential
to me and that is backup/restore databases to a file.
>Does anyone know of a free tool that can just
backup/restore databases remotely. I dont really want to
have to use export/import data as things like triggers
get lost when using Microsoft Web data administrator.
>A free web tool written in ASP.NET or ASP would be
ideal. But php would also be fine.
>Thanks
>.
>|||SQL server itself can backup/restore yes. But the remote web admin tool cann
ot.. it can only import/export data which does not include things like trigg
ers.
See this page:
http://www.databasejournal.com/feat...10894_3330301_2
And I quote:
"Database Administration Functions missing from Web Data Administration tool
- Can't create a database backup and restore a database "|||The article also says:
Even though these are not provided with the tool, some of
these items can be performed by using the Query tool to
submit T-SQL code to perform these tasks.
You can do backups and restores through T-SQL. In many
cases, most of what any of the tools do can be done in
T-SQL.
-Sue
On Thu, 8 Apr 2004 12:46:05 -0700, "GregD"
<anonymous@.discussions.microsoft.com> wrote:

>SQL server itself can backup/restore yes. But the remote web admin tool can
not.. it can only import/export data which does not include things like trig
gers.
>See this page:
>http://www.databasejournal.com/feat...10894_3330301_2
>And I quote:
>"Database Administration Functions missing from Web Data Administration too
l
>- Can't create a database backup and restore a database "|||Hi Sue,
What would the syntax be for backup/restore in TSQL? Or do you have a link w
here I can find this out myself?
Thanks for your help.|||No matter found it myself on MSDN:
BACKUP DATABASE DBNameGoesHere
TO DISK = 'C:\temp\Somefilename.bak'
WITH INIT
RESTORE DATABASE DBNameGoesHere
FROM DISK = 'C:\temp\Somefilename.bak'
WITH REPLACE|||Books Online is available within the SQL Server program group (assuming =
that you have SQL Server installed). =20
Books Online can be downloaded separately if necessary:
http://www.microsoft.com/sql/downloads/default.asp
Here is the specific link to the BOL download:
http://www.microsoft.com/sql/techin.../2000/books.asp
--=20
Keith
"GregD" <anonymous@.discussions.microsoft.com> wrote in message =
news:FBB86780-E276-4A02-B618-A7360E899FDC@.microsoft.com...
> No matter found it myself on MSDN:
>=20
> BACKUP DATABASE DBNameGoesHere
> TO DISK =3D 'C:\temp\Somefilename.bak'
> WITH INIT
>=20
> RESTORE DATABASE DBNameGoesHere
> FROM DISK =3D 'C:\temp\Somefilename.bak'
> WITH REPLACE

Backup Up Remote Database

Our database is on a server provided by the web host. I would like to
backup the data from this database more often than our web host performs
backups. But since our database shares space on its server with other
companies, we are not permitted to use the Enterprise Manager Backup
utility. (The same limitation occurs with the Copy Database Wizard and with
Detach/Attach methods of backing up.)
We considered using DTS to perform the backup on a scheduled basis; we could
copy the database content to a text or Excel file, and then regenerate the
database when it necessary to recover from a lost database. However, DTS
does not completely satisfy our needs, because the structure of the database
(tables and fields) will change occasionally, and we would prefer not to
have to make corresponding changes to the DTS package (and then retest the
package) when this happens. In other words, it would be ideal if DTS could
be used to copy all fields from the database table.
What do other companies do to ensure the integrity of their data without
relying upon the hosting company?Hi
You could create your own scheduled job that runs the T-SQL backup command!
Jasper's expressmaint procedure does this an more!
http://www.sqldbatips.com/showcode.asp?ID=26
John
"Hondo" wrote:

> Our database is on a server provided by the web host. I would like to
> backup the data from this database more often than our web host performs
> backups. But since our database shares space on its server with other
> companies, we are not permitted to use the Enterprise Manager Backup
> utility. (The same limitation occurs with the Copy Database Wizard and wi
th
> Detach/Attach methods of backing up.)
> We considered using DTS to perform the backup on a scheduled basis; we cou
ld
> copy the database content to a text or Excel file, and then regenerate the
> database when it necessary to recover from a lost database. However, DTS
> does not completely satisfy our needs, because the structure of the databa
se
> (tables and fields) will change occasionally, and we would prefer not to
> have to make corresponding changes to the DTS package (and then retest the
> package) when this happens. In other words, it would be ideal if DTS coul
d
> be used to copy all fields from the database table.
> What do other companies do to ensure the integrity of their data without
> relying upon the hosting company?
>
>

Backup Up Remote Database

Our database is on a server provided by the web host. I would like to
backup the data from this database more often than our web host performs
backups. But since our database shares space on its server with other
companies, we are not permitted to use the Enterprise Manager Backup
utility. (The same limitation occurs with the Copy Database Wizard and with
Detach/Attach methods of backing up.)
We considered using DTS to perform the backup on a scheduled basis; we could
copy the database content to a text or Excel file, and then regenerate the
database when it necessary to recover from a lost database. However, DTS
does not completely satisfy our needs, because the structure of the database
(tables and fields) will change occasionally, and we would prefer not to
have to make corresponding changes to the DTS package (and then retest the
package) when this happens. In other words, it would be ideal if DTS could
be used to copy all fields from the database table.
What do other companies do to ensure the integrity of their data without
relying upon the hosting company?Hi
You could create your own scheduled job that runs the T-SQL backup command!
Jasper's expressmaint procedure does this an more!
http://www.sqldbatips.com/showcode.asp?ID=26
John
"Hondo" wrote:

> Our database is on a server provided by the web host. I would like to
> backup the data from this database more often than our web host performs
> backups. But since our database shares space on its server with other
> companies, we are not permitted to use the Enterprise Manager Backup
> utility. (The same limitation occurs with the Copy Database Wizard and wi
th
> Detach/Attach methods of backing up.)
> We considered using DTS to perform the backup on a scheduled basis; we cou
ld
> copy the database content to a text or Excel file, and then regenerate the
> database when it necessary to recover from a lost database. However, DTS
> does not completely satisfy our needs, because the structure of the databa
se
> (tables and fields) will change occasionally, and we would prefer not to
> have to make corresponding changes to the DTS package (and then retest the
> package) when this happens. In other words, it would be ideal if DTS coul
d
> be used to copy all fields from the database table.
> What do other companies do to ensure the integrity of their data without
> relying upon the hosting company?
>
>

Backup Up Remote Database

Our database is on a server provided by the web host. I would like to
backup the data from this database more often than our web host performs
backups. But since our database shares space on its server with other
companies, we are not permitted to use the Enterprise Manager Backup
utility. (The same limitation occurs with the Copy Database Wizard and with
Detach/Attach methods of backing up.)
We considered using DTS to perform the backup on a scheduled basis; we could
copy the database content to a text or Excel file, and then regenerate the
database when it necessary to recover from a lost database. However, DTS
does not completely satisfy our needs, because the structure of the database
(tables and fields) will change occasionally, and we would prefer not to
have to make corresponding changes to the DTS package (and then retest the
package) when this happens. In other words, it would be ideal if DTS could
be used to copy all fields from the database table.
What do other companies do to ensure the integrity of their data without
relying upon the hosting company?
Hi
You could create your own scheduled job that runs the T-SQL backup command!
Jasper's expressmaint procedure does this an more!
http://www.sqldbatips.com/showcode.asp?ID=26
John
"Hondo" wrote:

> Our database is on a server provided by the web host. I would like to
> backup the data from this database more often than our web host performs
> backups. But since our database shares space on its server with other
> companies, we are not permitted to use the Enterprise Manager Backup
> utility. (The same limitation occurs with the Copy Database Wizard and with
> Detach/Attach methods of backing up.)
> We considered using DTS to perform the backup on a scheduled basis; we could
> copy the database content to a text or Excel file, and then regenerate the
> database when it necessary to recover from a lost database. However, DTS
> does not completely satisfy our needs, because the structure of the database
> (tables and fields) will change occasionally, and we would prefer not to
> have to make corresponding changes to the DTS package (and then retest the
> package) when this happens. In other words, it would be ideal if DTS could
> be used to copy all fields from the database table.
> What do other companies do to ensure the integrity of their data without
> relying upon the hosting company?
>
>

Backup Up Remote Database

Our database is on a server provided by the web host. I would like to
backup the data from this database more often than our web host performs
backups. But since our database shares space on its server with other
companies, we are not permitted to use the Enterprise Manager Backup
utility. (The same limitation occurs with the Copy Database Wizard and with
Detach/Attach methods of backing up.)
We considered using DTS to perform the backup on a scheduled basis; we could
copy the database content to a text or Excel file, and then regenerate the
database when it necessary to recover from a lost database. However, DTS
does not completely satisfy our needs, because the structure of the database
(tables and fields) will change occasionally, and we would prefer not to
have to make corresponding changes to the DTS package (and then retest the
package) when this happens. In other words, it would be ideal if DTS could
be used to copy all fields from the database table.
What do other companies do to ensure the integrity of their data without
relying upon the hosting company?Hi
You could create your own scheduled job that runs the T-SQL backup command!
Jasper's expressmaint procedure does this an more!
http://www.sqldbatips.com/showcode.asp?ID=26
John
"Hondo" wrote:
> Our database is on a server provided by the web host. I would like to
> backup the data from this database more often than our web host performs
> backups. But since our database shares space on its server with other
> companies, we are not permitted to use the Enterprise Manager Backup
> utility. (The same limitation occurs with the Copy Database Wizard and with
> Detach/Attach methods of backing up.)
> We considered using DTS to perform the backup on a scheduled basis; we could
> copy the database content to a text or Excel file, and then regenerate the
> database when it necessary to recover from a lost database. However, DTS
> does not completely satisfy our needs, because the structure of the database
> (tables and fields) will change occasionally, and we would prefer not to
> have to make corresponding changes to the DTS package (and then retest the
> package) when this happens. In other words, it would be ideal if DTS could
> be used to copy all fields from the database table.
> What do other companies do to ensure the integrity of their data without
> relying upon the hosting company?
>
>