Data File in a Different machine on the network.

Hi All,

I have a requirement to create the database with data and log files in
a different machine on the network.

Googling, I got a link which said Mapped drives do not work but UNC paths
work. However in my case, both are failing.

Any advices or links on net will be highly useful.

Thanks and Regards,
Chandra MohanDon't do this. It's not supported by Microsoft, you will lose all the
benefits of a client-server database and you risk corrupting your data.

Read this article:

http://www.mssqlserver.com/faq/gene...tworkdrives.asp

--
David Portas
----
Please reply only to the newsgroup
--|||bschandramohan@.yahoo.com (Chandra Mohan) wrote in message news:<bb0ef6.0309282105.59f0d698@.posting.google.com>...
> Hi All,
> I have a requirement to create the database with data and log files in
> a different machine on the network.
> Googling, I got a link which said Mapped drives do not work but UNC paths
> work. However in my case, both are failing.
> Any advices or links on net will be highly useful.
> Thanks and Regards,
> Chandra Mohan

Check this KB article:

http://support.microsoft.com/defaul...1&Product=sql2k

You can put database files on network drives by setting trace flag
1807, but it is not supported unless the files are on a NAS which is
specifically certified for SQL Server. Often, the NAS will make the
network drive appear like a local one, so you won't need to set the
trace flag on anyway.

Putting a database on a normal UNC share is a very bad idea - you
won't be able to guarantee data integrity and performance will suffer.

Simon|||David Portas (REMOVE_BEFORE_REPLYING_dportas@.acm.org) writes:
> Don't do this. It's not supported by Microsoft, you will lose all the
> benefits of a client-server database and you risk corrupting your data.

I agree that putting a database on a network drive is an extremely bad
idea, but I don't see where the client-server issue comes in. You can
still connect a lots of clients to that database, as if the database
had been a drive local to the database server. (Well, lots and lots.
If there are lots, corruption might appear within the hour.)

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||What I had in mind was that you lose the performance advantage (compared to
a desktop database running on a network) of server-based processing. And you
sacrifice much of the resilience of transaction management and logging.

--
David Portas
----
Please reply only to the newsgroup
--

"Erland Sommarskog" <sommar@.algonet.se> wrote in message
news:Xns9405EBB63563DYazorman@.127.0.0.1...
> David Portas (REMOVE_BEFORE_REPLYING_dportas@.acm.org) writes:
> > Don't do this. It's not supported by Microsoft, you will lose all the
> > benefits of a client-server database and you risk corrupting your data.
> I agree that putting a database on a network drive is an extremely bad
> idea, but I don't see where the client-server issue comes in. You can
> still connect a lots of clients to that database, as if the database
> had been a drive local to the database server. (Well, lots and lots.
> If there are lots, corruption might appear within the hour.)
>
> --
> Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp|||David Portas (REMOVE_BEFORE_REPLYING_dportas@.acm.org) writes:
> What I had in mind was that you lose the performance advantage (compared
> to a desktop database running on a network) of server-based processing.
> And you sacrifice much of the resilience of transaction management and
> logging.

You mean that rather running client on machine A and server on machine B,
we're running both server and client on A, and only have the database files
on B.

Yes, this is killing the client-server concept. (Ever heard of Visual
SourceSafe? That's an example of this architecture.)

I don't know why people want to put databases on network devices, but
my assumption is that the most common reason is simply space constraint
on the server, so they try to rent space somewhere else in the network.
In this case, I guess clients still connect from somewhere else.

But rather than renting the space, it's better to rent the entire disk
and move into cabinet. Or see your local hardware dealer...

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Data Driven Subscriptions unavailable, please help

I'm running sql2000 Standard with SP4 applied. I also have Reporting Services 2000 with service packs running on the same machine. I'm trying to get a data-driven subscription, but the button to access is unavailable.

I've assigned the account I'm working under the Publisher role and have modified this role to have all permissions (including managing subscriptions). I have stored credentials with my data source as well.

I can create a standard subscription with no problems, but just don't get the button to do the data-driven option.

Any assistance is appreciated.

You are running RS 2000 Standard Edition. Data driven subscriptions are only available on Enterprise Edition and Developer Edition.

The same applies to data driven subscriptions on RS 2005: http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx

-- Robert

|||Is it possible to run the enterprise edition of Reporting Services on the Standard edition of SQL 2000?|||

Actually, you can run a Reporting Services Enterprise Edition with its metadata store on a SQL Server Standard Edition.

-- Robert

|||We have the same issue and we are using the enterprise version. The user who is trying to set-up the data-driven subscription is also an admin on the report server settings...|||

Does anybody know the license implications if you install reporting services 2000 enterprise on a sql server 2000 standard install?

|||Does anybody know the license implications if you install reporting services 2000 enterprise on a sql server 2000 standard install?

Data Driven Subscriptions unavailable, please help

I'm running sql2000 Standard with SP4 applied. I also have Reporting Services 2000 with service packs running on the same machine. I'm trying to get a data-driven subscription, but the button to access is unavailable.

I've assigned the account I'm working under the Publisher role and have modified this role to have all permissions (including managing subscriptions). I have stored credentials with my data source as well.

I can create a standard subscription with no problems, but just don't get the button to do the data-driven option.

Any assistance is appreciated.

You are running RS 2000 Standard Edition. Data driven subscriptions are only available on Enterprise Edition and Developer Edition.

The same applies to data driven subscriptions on RS 2005: http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx

-- Robert

|||Is it possible to run the enterprise edition of Reporting Services on the Standard edition of SQL 2000?|||

Actually, you can run a Reporting Services Enterprise Edition with its metadata store on a SQL Server Standard Edition.

-- Robert

|||We have the same issue and we are using the enterprise version. The user who is trying to set-up the data-driven subscription is also an admin on the report server settings...|||

Does anybody know the license implications if you install reporting services 2000 enterprise on a sql server 2000 standard install?

|||Does anybody know the license implications if you install reporting services 2000 enterprise on a sql server 2000 standard install?sql

Data Driven Subscriptions unavailable, please help

I'm running sql2000 Standard with SP4 applied. I also have Reporting Services 2000 with service packs running on the same machine. I'm trying to get a data-driven subscription, but the button to access is unavailable.

I've assigned the account I'm working under the Publisher role and have modified this role to have all permissions (including managing subscriptions). I have stored credentials with my data source as well.

I can create a standard subscription with no problems, but just don't get the button to do the data-driven option.

Any assistance is appreciated.

You are running RS 2000 Standard Edition. Data driven subscriptions are only available on Enterprise Edition and Developer Edition.

The same applies to data driven subscriptions on RS 2005: http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx

-- Robert

|||Is it possible to run the enterprise edition of Reporting Services on the Standard edition of SQL 2000?|||

Actually, you can run a Reporting Services Enterprise Edition with its metadata store on a SQL Server Standard Edition.

-- Robert

|||We have the same issue and we are using the enterprise version. The user who is trying to set-up the data-driven subscription is also an admin on the report server settings...|||

Does anybody know the license implications if you install reporting services 2000 enterprise on a sql server 2000 standard install?

|||Does anybody know the license implications if you install reporting services 2000 enterprise on a sql server 2000 standard install?

Data Backup to CDROM

Is there any software that can make backup of data from MSSQL Server, LIVE - during work - to another machine on CDROM?
Anybody has the experience - good or bad with the CD solution?You mean that you want to buy something to do what SQL Server itself does?

-PatP

Data access from Report Server

Here is my problem. I am using code in a report that uses the System.Data
dll to access data from a remote SQL Server. On my development machine, I
can view the report without a problem. When I deploy the report to the
Report Server (Windows Server 2003), I get the following:
Request For The Permission Of Type
System.Data.Sqlclient.Sqlclientpermission, System.Data, Version=1
I followed the steps in article 842419 to allow the permissions for this
assembly, but I still can not get it to work.I am having the exect same problem.
"dyarbrough" wrote:
> Here is my problem. I am using code in a report that uses the System.Data
> dll to access data from a remote SQL Server. On my development machine, I
> can view the report without a problem. When I deploy the report to the
> Report Server (Windows Server 2003), I get the following:
> Request For The Permission Of Type
> System.Data.Sqlclient.Sqlclientpermission, System.Data, Version=1
> I followed the steps in article 842419 to allow the permissions for this
> assembly, but I still can not get it to work.

CXPACKET and XEON Processors

I have a question that I hope someone can answer. We are
running a WIN2K Server with SQL Server 2K SP 3. It is a
dual xeon processor machine with hyperthreading enabled.
I have noticed that the SQL PERF (Waitstats) CXPACKET is
much higher with xeon processors and was told that WIN2K3
would help with the lock times with the threading. Can
anyone speak to this? I have disabled the hyperthreading
at the BIOS level and noticed a higher level of
performance on the WIN2K machine.
Thanks
GregYou might try reducing 'max degree of parallelism' configuration option
rather than disable hyperthreading. If this is an OLTP system that
doesn't really benefit from parallel queries, try setting it to 1.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Greg" <greg@.stockamp.com> wrote in message
news:141001c3822d$d7be2d90$a001280a@.phx.gbl...
> I have a question that I hope someone can answer. We are
> running a WIN2K Server with SQL Server 2K SP 3. It is a
> dual xeon processor machine with hyperthreading enabled.
> I have noticed that the SQL PERF (Waitstats) CXPACKET is
> much higher with xeon processors and was told that WIN2K3
> would help with the lock times with the threading. Can
> anyone speak to this? I have disabled the hyperthreading
> at the BIOS level and noticed a higher level of
> performance on the WIN2K machine.
> Thanks
> Greg|||Waittype on CXPACKET is normal for parallel queries. Do not reduce MAXDOP
because you see waits on CXPACKET, reduce MAXDOP because you've proven it
makes queries you care about go faster.
--
Kevin Connell, MCDBA
----
The views expressed here are my own
and not of my employer.
----
"Greg" <greg@.stockamp.com> wrote in message
news:141001c3822d$d7be2d90$a001280a@.phx.gbl...
> I have a question that I hope someone can answer. We are
> running a WIN2K Server with SQL Server 2K SP 3. It is a
> dual xeon processor machine with hyperthreading enabled.
> I have noticed that the SQL PERF (Waitstats) CXPACKET is
> much higher with xeon processors and was told that WIN2K3
> would help with the lock times with the threading. Can
> anyone speak to this? I have disabled the hyperthreading
> at the BIOS level and noticed a higher level of
> performance on the WIN2K machine.
> Thanks
> Greg