Location of transaction log on another machine

Hi,
We have SQL server 2000 enterprise edition installed on a machine with
only one hard drive. On this server we have a small but critical
database. I have noticed that the person who created this database
placed the location of the transaction log on the same machine as the
data file.
Can I move the transaction log to another machine on the network that
doesn't have SQL server installed? Will there be a performance hit if
SQL Server has to write to this log over the network? If so will it be
major?
I know ideally we should be using a RAID setup of some sort, but for
finacial and political reasons this is not an option.
Cheers,
Steve
Basically, SQL Server doesn't support this. Doing it would be a big performance hit for
modifications. For the full story, check out
http://support.microsoft.com/default...b;en-us;304261
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Steve" <steve.hager@.gmail.com> wrote in message
news:d5c55fd1.0412012214.76710133@.posting.google.c om...
> Hi,
> We have SQL server 2000 enterprise edition installed on a machine with
> only one hard drive. On this server we have a small but critical
> database. I have noticed that the person who created this database
> placed the location of the transaction log on the same machine as the
> data file.
> Can I move the transaction log to another machine on the network that
> doesn't have SQL server installed? Will there be a performance hit if
> SQL Server has to write to this log over the network? If so will it be
> major?
> I know ideally we should be using a RAID setup of some sort, but for
> finacial and political reasons this is not an option.
> Cheers,
>
> Steve
|||Steve wrote:
> Hi,
> We have SQL server 2000 enterprise edition installed on a machine with
> only one hard drive. On this server we have a small but critical
> database. I have noticed that the person who created this database
> placed the location of the transaction log on the same machine as the
> data file.
> Can I move the transaction log to another machine on the network that
> doesn't have SQL server installed? Will there be a performance hit if
> SQL Server has to write to this log over the network? If so will it be
> major?
> I know ideally we should be using a RAID setup of some sort, but for
> finacial and political reasons this is not an option.
> Cheers,
>
> Steve
How about another hard drive. That's no too much money...
If it's a small database, it'll probably be fine.
David Gugick
Imceda Software
www.imceda.com

Location of transaction log on another machine

Hi,
We have SQL server 2000 enterprise edition installed on a machine with
only one hard drive. On this server we have a small but critical
database. I have noticed that the person who created this database
placed the location of the transaction log on the same machine as the
data file.
Can I move the transaction log to another machine on the network that
doesn't have SQL server installed? Will there be a performance hit if
SQL Server has to write to this log over the network? If so will it be
major?
I know ideally we should be using a RAID setup of some sort, but for
finacial and political reasons this is not an option.
Cheers,
SteveBasically, SQL Server doesn't support this. Doing it would be a big performa
nce hit for
modifications. For the full story, check out
http://support.microsoft.com/defaul...kb;en-us;304261
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Steve" <steve.hager@.gmail.com> wrote in message
news:d5c55fd1.0412012214.76710133@.posting.google.com...
> Hi,
> We have SQL server 2000 enterprise edition installed on a machine with
> only one hard drive. On this server we have a small but critical
> database. I have noticed that the person who created this database
> placed the location of the transaction log on the same machine as the
> data file.
> Can I move the transaction log to another machine on the network that
> doesn't have SQL server installed? Will there be a performance hit if
> SQL Server has to write to this log over the network? If so will it be
> major?
> I know ideally we should be using a RAID setup of some sort, but for
> finacial and political reasons this is not an option.
> Cheers,
>
> Steve|||Steve wrote:
> Hi,
> We have SQL server 2000 enterprise edition installed on a machine with
> only one hard drive. On this server we have a small but critical
> database. I have noticed that the person who created this database
> placed the location of the transaction log on the same machine as the
> data file.
> Can I move the transaction log to another machine on the network that
> doesn't have SQL server installed? Will there be a performance hit if
> SQL Server has to write to this log over the network? If so will it be
> major?
> I know ideally we should be using a RAID setup of some sort, but for
> finacial and political reasons this is not an option.
> Cheers,
>
> Steve
How about another hard drive. That's no too much money...
If it's a small database, it'll probably be fine.
David Gugick
Imceda Software
www.imceda.com

Location of transaction log on another machine

Hi,
We have SQL server 2000 enterprise edition installed on a machine with
only one hard drive. On this server we have a small but critical
database. I have noticed that the person who created this database
placed the location of the transaction log on the same machine as the
data file.
Can I move the transaction log to another machine on the network that
doesn't have SQL server installed? Will there be a performance hit if
SQL Server has to write to this log over the network? If so will it be
major?
I know ideally we should be using a RAID setup of some sort, but for
finacial and political reasons this is not an option.
Cheers,
SteveBasically, SQL Server doesn't support this. Doing it would be a big performance hit for
modifications. For the full story, check out
http://support.microsoft.com/default.aspx?scid=kb;en-us;304261
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Steve" <steve.hager@.gmail.com> wrote in message
news:d5c55fd1.0412012214.76710133@.posting.google.com...
> Hi,
> We have SQL server 2000 enterprise edition installed on a machine with
> only one hard drive. On this server we have a small but critical
> database. I have noticed that the person who created this database
> placed the location of the transaction log on the same machine as the
> data file.
> Can I move the transaction log to another machine on the network that
> doesn't have SQL server installed? Will there be a performance hit if
> SQL Server has to write to this log over the network? If so will it be
> major?
> I know ideally we should be using a RAID setup of some sort, but for
> finacial and political reasons this is not an option.
> Cheers,
>
> Steve|||Steve wrote:
> Hi,
> We have SQL server 2000 enterprise edition installed on a machine with
> only one hard drive. On this server we have a small but critical
> database. I have noticed that the person who created this database
> placed the location of the transaction log on the same machine as the
> data file.
> Can I move the transaction log to another machine on the network that
> doesn't have SQL server installed? Will there be a performance hit if
> SQL Server has to write to this log over the network? If so will it be
> major?
> I know ideally we should be using a RAID setup of some sort, but for
> finacial and political reasons this is not an option.
> Cheers,
>
> Steve
How about another hard drive. That's no too much money...
If it's a small database, it'll probably be fine.
David Gugick
Imceda Software
www.imceda.com

Location of the Audit Log

This should be an easy one: when I turn on the Audit Log, what directory and
what is the log called? Can I send the log to a drive other than the drive
I have my data files on?SQL Server auditing is sent to the NT Event logs.
Is this what you are asking?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||I need the name of the file SQL Server creates. I am looking in that config
folder and ther is at least 14 NT files in this thing!|||Errorlogs are sent to the drive specified by this registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\Parameters
SQLArg1
Hope this helps.
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||got it! Thanks for all your help!

location of subscription database?

Hi, I have set up transactional replication. I have specified the folder
that the snapshot is to reside in (on our SAN). But how does one specify the
location of the database tables on the subscriber end? I wish to place the
..mdf and .ldf that the subecriber picks up, in a pre-defined location. I
cannot see it in the publisher properties or the agent properties. I can
only see the option to define the 'snapshot location' .. but what about the
subecriber database location? any help most appreciated!
I installed a fresh instance of SQL as the subscriber. I created the
publication and pushed it to the subscriber. Do i have to create a dummy
database (with same name as the database to be replicated) on the subecriber
and predefine the location of the .mdf and .ldf files before i start the
transactional replication? What steps am i missing?
Any help most appreciated!
cheers, john
Did you create a subscription yet? During that, it asks you where you want to
put your replicated db. You can create that prior to your setup and point
your subscription to point to that db. Also, when you are creating the
subscription, it asks you for the subscription db. At this time, you can
chose the one you created or you can create one with all the things you want
to define.
Tejas
|||Replication needs a preexisting database. There is no way to deploy a
database through replication.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"john r" <johnr@.trailer.com> wrote in message
news:%23z1ChEF8FHA.3200@.TK2MSFTNGP11.phx.gbl...
> Hi, I have set up transactional replication. I have specified the folder
> that the snapshot is to reside in (on our SAN). But how does one specify
> the location of the database tables on the subscriber end? I wish to place
> the .mdf and .ldf that the subecriber picks up, in a pre-defined location.
> I cannot see it in the publisher properties or the agent properties. I can
> only see the option to define the 'snapshot location' .. but what about
> the subecriber database location? any help most appreciated!
> I installed a fresh instance of SQL as the subscriber. I created the
> publication and pushed it to the subscriber. Do i have to create a dummy
> database (with same name as the database to be replicated) on the
> subecriber and predefine the location of the .mdf and .ldf files before i
> start the transactional replication? What steps am i missing?
> Any help most appreciated!
> cheers, john
>
|||Hilary, when you are creating a subscription through the Create subscription
Wizard, What's the "Choose Destination Database"? There, it says browse or
create and when you click on it, It has a button to "Create New" and when you
click that, doesn't it allow you to replicate to the newly created db? Am i
missing something? Please tell me if i'm wrong. Thank you.
Tejas.
|||You are completely correct here Tejas. But if you script your subscription
out and then modify it for another subscriber which does not have the
subscription database it will not create it and the agent will fail. Or if
you deploy the subscription to a subscription group or multiple subscribers
you will not have the option to precreate the subscription database through
the Wizard.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tejas Parikh" <TejasParikh@.discussions.microsoft.com> wrote in message
news:7BE03DE5-DA5F-43E5-A9C6-1CEBCF44EAD5@.microsoft.com...
> Hilary, when you are creating a subscription through the Create
> subscription
> Wizard, What's the "Choose Destination Database"? There, it says browse or
> create and when you click on it, It has a button to "Create New" and when
> you
> click that, doesn't it allow you to replicate to the newly created db? Am
> i
> missing something? Please tell me if i'm wrong. Thank you.
> Tejas.

Location of SQL-datafile after installation of VB 2005 DB-application

Hello Experts,

I am relatively new to VB 2005 and SQL Express. I have a question concerning where I can find the SQL-database file (*.mdf) after I have installed (published) my VB 2005 database-application (the *.mdf file was created by Visual Studio Express?). It seems it is nowhere in the disk of the of pc it is installed on. So, what happens to *.mdf file after installation of the application, in what way I can connect to the *.mdf file after the application - the file is part of - is published?

In need of help,

MY

That depends on wheter you are using User instances (standalone mdf files with a SQL Server Express) or server attached files. User instances are normally put in the app_Data directory, whereas saved and marked for deploy and installation will be placed in the appropiate configured folder.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||Thank you for your reply,

I found finally the *.mdf files (along with the rest of the program files) installed as hidden folders under C:\Documents and Settings\User\Local Settings\...Data\. So, in this respect problem is solved. Obviously, I was using User Instances - at least in the end of my app's ConnectionString I was "User Instance=True". Does this mean that I am using user instances? - And if I mark "User Instance=False" will the installation program automatically attach the *.mdf data file then to SQL Express local server?

And if so, then I have another troublesome question. I am creating an VB DB-application whose DB-structure will change later (further tables will be added later). And my client will add data already data into database of preliminary version. Then I later will update / redeploy (with ClickOnce method) the application - so will the redeployment of the new version of application overwrite the data in SQL-database of older version? - i.e. does the new database file (with nothing or meaningless test data in it) replace the older database content (It would be serious damage to overwrite that data). The change of DB-structure is a another problem.

Could you, please, clarify for me what should I do,

Matti

|||

ClickOnce installation replaces all of the project files, including your database file. This is a short comming in how VS handles database files in 2005. You'll have to find an alternative way to deal with deployment within the ClickOnce framework.

Happily, you can watch the web cast I recorded discussing just such an alternative, links to both the 'cast and the source code demonstrated are available from this blog post.

Mike

|||

Mike,

thank you very much for your reply - and your SQL Server Express WebLog. That is all now and in coming days very important information for me that.

Well, I have started to consider not to include mdf-file in the deployment process at all but install (attach) it manually on a deployment pc via SQL Server Management Studio Express (which of course needs then to be installed on the deployment pc as well). In this way I will not certainly touch in the process of redeployment / update the inserted data in DB.

Also this makes the future changes of DB-structure easier for me; I can perform them through SSMS via SQL: simply add here new tables and relationships.

Thank you,

MY

Location of SQL-datafile after installation of VB 2005 DB-application

Hello Experts,

I am relatively new to VB 2005 and SQL Express. I have a question concerning where I can find the SQL-database file (*.mdf) after I have installed (published) my VB 2005 database-application (the *.mdf file was created by Visual Studio Express?). It seems it is nowhere in the disk of the of pc it is installed on. So, what happens to *.mdf file after installation of the application, in what way I can connect to the *.mdf file after the application - the file is part of - is published?

In need of help,

MY

That depends on wheter you are using User instances (standalone mdf files with a SQL Server Express) or server attached files. User instances are normally put in the app_Data directory, whereas saved and marked for deploy and installation will be placed in the appropiate configured folder.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||Thank you for your reply,

I found finally the *.mdf files (along with the rest of the program files) installed as hidden folders under C:\Documents and Settings\User\Local Settings\...Data\. So, in this respect problem is solved. Obviously, I was using User Instances - at least in the end of my app's ConnectionString I was "User Instance=True". Does this mean that I am using user instances? - And if I mark "User Instance=False" will the installation program automatically attach the *.mdf data file then to SQL Express local server?

And if so, then I have another troublesome question. I am creating an VB DB-application whose DB-structure will change later (further tables will be added later). And my client will add data already data into database of preliminary version. Then I later will update / redeploy (with ClickOnce method) the application - so will the redeployment of the new version of application overwrite the data in SQL-database of older version? - i.e. does the new database file (with nothing or meaningless test data in it) replace the older database content (It would be serious damage to overwrite that data). The change of DB-structure is a another problem.

Could you, please, clarify for me what should I do,

Matti

|||

ClickOnce installation replaces all of the project files, including your database file. This is a short comming in how VS handles database files in 2005. You'll have to find an alternative way to deal with deployment within the ClickOnce framework.

Happily, you can watch the web cast I recorded discussing just such an alternative, links to both the 'cast and the source code demonstrated are available from this blog post.

Mike

|||

Mike,

thank you very much for your reply - and your SQL Server Express WebLog. That is all now and in coming days very important information for me that.

Well, I have started to consider not to include mdf-file in the deployment process at all but install (attach) it manually on a deployment pc via SQL Server Management Studio Express (which of course needs then to be installed on the deployment pc as well). In this way I will not certainly touch in the process of redeployment / update the inserted data in DB.

Also this makes the future changes of DB-structure easier for me; I can perform them through SSMS via SQL: simply add here new tables and relationships.

Thank you,

MY

Location of SQL Server Express

Can i put sql sever on my computer and have the db on a mapped drive on our company network?

Mapped Drive -No;

Logical Drive (LUN) -Yes

Does your network have a NAS or SAN? (That would work.) Just mapping to a file server does not.

sql

Location of SQL

I have an SQL server with a number of databses including :
Sharepoint and SMS. I would like to move these databases to the D
partition and they are currently in the C:\ partition.
How can this be done ?
Easiest is to us sp_detach_db and sp_attach_db (documented in Books Online).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"scuba19" <scuba19@.discussions.microsoft.com> wrote in message
news:D954B376-1C4F-449E-B25D-0DF5CDA0FA59@.microsoft.com...
>I have an SQL server with a number of databses including :
> Sharepoint and SMS. I would like to move these databases to the D
> partition and they are currently in the C:\ partition.
> How can this be done ?
|||options
1. Detach / Attach
2. Backup / Restore with MOVE
3. add files on d drive to file group
DBBC SHRINKFILE with EMPTRYFILE
drop old files
"scuba19" <scuba19@.discussions.microsoft.com> wrote in message
news:D954B376-1C4F-449E-B25D-0DF5CDA0FA59@.microsoft.com...
>I have an SQL server with a number of databses including :
> Sharepoint and SMS. I would like to move these databases to the D
> partition and they are currently in the C:\ partition.
> How can this be done ?
|||Hi thanks for your response. How Do I move the databses using EM ? Also
How do I attach , detack with EM ?
"jaylou" wrote:
[vbcol=seagreen]
> The easiest way would be to detach the databases, Move the MDF and LDF files
> to the new location and re-attach the databases.
> You can do this all in Enterprise Manager. You can also set the default
> location to your new location of these databases thru EM Properties of the
> Server.
> HTH,
> Joe
>
> "scuba19" wrote:
|||Hi , I found out how to detach but i am having the problem with one
datbase. A databse that is named tembdb which is 5GB in size
"jaylou" wrote:
[vbcol=seagreen]
> The easiest way would be to detach the databases, Move the MDF and LDF files
> to the new location and re-attach the databases.
> You can do this all in Enterprise Manager. You can also set the default
> location to your new location of these databases thru EM Properties of the
> Server.
> HTH,
> Joe
>
> "scuba19" wrote:
|||The easiest way would be to detach the databases, Move the MDF and LDF files
to the new location and re-attach the databases.
You can do this all in Enterprise Manager. You can also set the default
location to your new location of these databases thru EM Properties of the
Server.
HTH,
Joe
"scuba19" wrote:

> I have an SQL server with a number of databses including :
> Sharepoint and SMS. I would like to move these databases to the D
> partition and they are currently in the C:\ partition.
> How can this be done ?
|||tempdb is a system database that is used to proccess queryies...refer to
Books Online
to move this database you can simply use ALTER DATABASE...
if you restart your sql server ,this db will shrink back to its origional
size...determined by the settings of the model db
"scuba19" <scuba19@.discussions.microsoft.com> wrote in message
news:D3D4B487-6C03-41DE-AE62-BE5944C4D504@.microsoft.com...[vbcol=seagreen]
> Hi , I found out how to detach but i am having the problem with one
> datbase. A databse that is named tembdb which is 5GB in size
> "jaylou" wrote:
|||http://support.microsoft.com/default...22120121120120
"David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
news:uFfhhZNAGHA.356@.TK2MSFTNGP12.phx.gbl...
> tempdb is a system database that is used to proccess queryies...refer to
> Books Online
> to move this database you can simply use ALTER DATABASE...
> if you restart your sql server ,this db will shrink back to its origional
> size...determined by the settings of the model db
> "scuba19" <scuba19@.discussions.microsoft.com> wrote in message
> news:D3D4B487-6C03-41DE-AE62-BE5944C4D504@.microsoft.com...
>
|||I am not able to do this to a databse named tempdb which is 5 GB in size ?
"David J. Cartwright" wrote:

> options
> 1. Detach / Attach
> 2. Backup / Restore with MOVE
> 3. add files on d drive to file group
> DBBC SHRINKFILE with EMPTRYFILE
> drop old files
> "scuba19" <scuba19@.discussions.microsoft.com> wrote in message
> news:D954B376-1C4F-449E-B25D-0DF5CDA0FA59@.microsoft.com...
>
>
|||What problem are you having with TempDB? Did you move Master and model as
well?
I never tried to do this with system DBs only my own created DBs.
"scuba19" wrote:
[vbcol=seagreen]
> Hi , I found out how to detach but i am having the problem with one
> datbase. A databse that is named tembdb which is 5GB in size
> "jaylou" wrote:

Location of SQL

I have an SQL server with a number of databses including :
Sharepoint and SMS. I would like to move these databases to the D
partition and they are currently in the C:\ partition.
How can this be done ?Easiest is to us sp_detach_db and sp_attach_db (documented in Books Online).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"scuba19" <scuba19@.discussions.microsoft.com> wrote in message
news:D954B376-1C4F-449E-B25D-0DF5CDA0FA59@.microsoft.com...
>I have an SQL server with a number of databses including :
> Sharepoint and SMS. I would like to move these databases to the D
> partition and they are currently in the C:\ partition.
> How can this be done ?|||options
1. Detach / Attach
2. Backup / Restore with MOVE
3. add files on d drive to file group
DBBC SHRINKFILE with EMPTRYFILE
drop old files
"scuba19" <scuba19@.discussions.microsoft.com> wrote in message
news:D954B376-1C4F-449E-B25D-0DF5CDA0FA59@.microsoft.com...
>I have an SQL server with a number of databses including :
> Sharepoint and SMS. I would like to move these databases to the D
> partition and they are currently in the C:\ partition.
> How can this be done ?|||Hi thanks for your response. How Do I move the databses using EM ? Also
How do I attach , detack with EM ?
"jaylou" wrote:
[vbcol=seagreen]
> The easiest way would be to detach the databases, Move the MDF and LDF fil
es
> to the new location and re-attach the databases.
> You can do this all in Enterprise Manager. You can also set the default
> location to your new location of these databases thru EM Properties of the
> Server.
> HTH,
> Joe
>
> "scuba19" wrote:
>|||Hi , I found out how to detach but i am having the problem with one
datbase. A databse that is named tembdb which is 5GB in size
"jaylou" wrote:
[vbcol=seagreen]
> The easiest way would be to detach the databases, Move the MDF and LDF fil
es
> to the new location and re-attach the databases.
> You can do this all in Enterprise Manager. You can also set the default
> location to your new location of these databases thru EM Properties of the
> Server.
> HTH,
> Joe
>
> "scuba19" wrote:
>|||The easiest way would be to detach the databases, Move the MDF and LDF files
to the new location and re-attach the databases.
You can do this all in Enterprise Manager. You can also set the default
location to your new location of these databases thru EM Properties of the
Server.
HTH,
Joe
"scuba19" wrote:

> I have an SQL server with a number of databses including :
> Sharepoint and SMS. I would like to move these databases to the D
> partition and they are currently in the C:\ partition.
> How can this be done ?|||tempdb is a system database that is used to proccess queryies...refer to
Books Online
to move this database you can simply use ALTER DATABASE...
if you restart your sql server ,this db will shrink back to its origional
size...determined by the settings of the model db
"scuba19" <scuba19@.discussions.microsoft.com> wrote in message
news:D3D4B487-6C03-41DE-AE62-BE5944C4D504@.microsoft.com...[vbcol=seagreen]
> Hi , I found out how to detach but i am having the problem with one
> datbase. A databse that is named tembdb which is 5GB in size
> "jaylou" wrote:
>|||21120120" target="_blank">http://support.microsoft.com/defaul...br />
21120120
"David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
news:uFfhhZNAGHA.356@.TK2MSFTNGP12.phx.gbl...
> tempdb is a system database that is used to proccess queryies...refer to
> Books Online
> to move this database you can simply use ALTER DATABASE...
> if you restart your sql server ,this db will shrink back to its origional
> size...determined by the settings of the model db
> "scuba19" <scuba19@.discussions.microsoft.com> wrote in message
> news:D3D4B487-6C03-41DE-AE62-BE5944C4D504@.microsoft.com...
>|||I am not able to do this to a databse named tempdb which is 5 GB in size ?
"David J. Cartwright" wrote:

> options
> 1. Detach / Attach
> 2. Backup / Restore with MOVE
> 3. add files on d drive to file group
> DBBC SHRINKFILE with EMPTRYFILE
> drop old files
> "scuba19" <scuba19@.discussions.microsoft.com> wrote in message
> news:D954B376-1C4F-449E-B25D-0DF5CDA0FA59@.microsoft.com...
>
>|||What problem are you having with TempDB? Did you move Master and model as
well?
I never tried to do this with system DBs only my own created DBs.
"scuba19" wrote:
[vbcol=seagreen]
> Hi , I found out how to detach but i am having the problem with one
> datbase. A databse that is named tembdb which is 5GB in size
> "jaylou" wrote:
>

Location of SQL

I have an SQL server with a number of databses including :
Sharepoint and SMS. I would like to move these databases to the D
partition and they are currently in the C:\ partition.
How can this be done ?Easiest is to us sp_detach_db and sp_attach_db (documented in Books Online).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"scuba19" <scuba19@.discussions.microsoft.com> wrote in message
news:D954B376-1C4F-449E-B25D-0DF5CDA0FA59@.microsoft.com...
>I have an SQL server with a number of databses including :
> Sharepoint and SMS. I would like to move these databases to the D
> partition and they are currently in the C:\ partition.
> How can this be done ?|||options
1. Detach / Attach
2. Backup / Restore with MOVE
3. add files on d drive to file group
DBBC SHRINKFILE with EMPTRYFILE
drop old files
"scuba19" <scuba19@.discussions.microsoft.com> wrote in message
news:D954B376-1C4F-449E-B25D-0DF5CDA0FA59@.microsoft.com...
>I have an SQL server with a number of databses including :
> Sharepoint and SMS. I would like to move these databases to the D
> partition and they are currently in the C:\ partition.
> How can this be done ?|||Hi thanks for your response. How Do I move the databses using EM ? Also
How do I attach , detack with EM ?
"jaylou" wrote:
> The easiest way would be to detach the databases, Move the MDF and LDF files
> to the new location and re-attach the databases.
> You can do this all in Enterprise Manager. You can also set the default
> location to your new location of these databases thru EM Properties of the
> Server.
> HTH,
> Joe
>
> "scuba19" wrote:
> > I have an SQL server with a number of databses including :
> >
> > Sharepoint and SMS. I would like to move these databases to the D
> > partition and they are currently in the C:\ partition.
> >
> > How can this be done ?|||Hi , I found out how to detach but i am having the problem with one
datbase. A databse that is named tembdb which is 5GB in size
"jaylou" wrote:
> The easiest way would be to detach the databases, Move the MDF and LDF files
> to the new location and re-attach the databases.
> You can do this all in Enterprise Manager. You can also set the default
> location to your new location of these databases thru EM Properties of the
> Server.
> HTH,
> Joe
>
> "scuba19" wrote:
> > I have an SQL server with a number of databses including :
> >
> > Sharepoint and SMS. I would like to move these databases to the D
> > partition and they are currently in the C:\ partition.
> >
> > How can this be done ?|||The easiest way would be to detach the databases, Move the MDF and LDF files
to the new location and re-attach the databases.
You can do this all in Enterprise Manager. You can also set the default
location to your new location of these databases thru EM Properties of the
Server.
HTH,
Joe
"scuba19" wrote:
> I have an SQL server with a number of databses including :
> Sharepoint and SMS. I would like to move these databases to the D
> partition and they are currently in the C:\ partition.
> How can this be done ?|||tempdb is a system database that is used to proccess queryies...refer to
Books Online
to move this database you can simply use ALTER DATABASE...
if you restart your sql server ,this db will shrink back to its origional
size...determined by the settings of the model db
"scuba19" <scuba19@.discussions.microsoft.com> wrote in message
news:D3D4B487-6C03-41DE-AE62-BE5944C4D504@.microsoft.com...
> Hi , I found out how to detach but i am having the problem with one
> datbase. A databse that is named tembdb which is 5GB in size
> "jaylou" wrote:
>> The easiest way would be to detach the databases, Move the MDF and LDF
>> files
>> to the new location and re-attach the databases.
>> You can do this all in Enterprise Manager. You can also set the default
>> location to your new location of these databases thru EM Properties of
>> the
>> Server.
>> HTH,
>> Joe
>>
>> "scuba19" wrote:
>> > I have an SQL server with a number of databses including :
>> >
>> > Sharepoint and SMS. I would like to move these databases to the D
>> > partition and they are currently in the C:\ partition.
>> >
>> > How can this be done ?|||http://support.microsoft.com/default.aspx?scid=kb;en-us;224071#XSLTH3207121122120121120120
"David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
news:uFfhhZNAGHA.356@.TK2MSFTNGP12.phx.gbl...
> tempdb is a system database that is used to proccess queryies...refer to
> Books Online
> to move this database you can simply use ALTER DATABASE...
> if you restart your sql server ,this db will shrink back to its origional
> size...determined by the settings of the model db
> "scuba19" <scuba19@.discussions.microsoft.com> wrote in message
> news:D3D4B487-6C03-41DE-AE62-BE5944C4D504@.microsoft.com...
>> Hi , I found out how to detach but i am having the problem with one
>> datbase. A databse that is named tembdb which is 5GB in size
>> "jaylou" wrote:
>> The easiest way would be to detach the databases, Move the MDF and LDF
>> files
>> to the new location and re-attach the databases.
>> You can do this all in Enterprise Manager. You can also set the default
>> location to your new location of these databases thru EM Properties of
>> the
>> Server.
>> HTH,
>> Joe
>>
>> "scuba19" wrote:
>> > I have an SQL server with a number of databses including :
>> >
>> > Sharepoint and SMS. I would like to move these databases to the D
>> > partition and they are currently in the C:\ partition.
>> >
>> > How can this be done ?
>|||I am not able to do this to a databse named tempdb which is 5 GB in size ?
"David J. Cartwright" wrote:
> options
> 1. Detach / Attach
> 2. Backup / Restore with MOVE
> 3. add files on d drive to file group
> DBBC SHRINKFILE with EMPTRYFILE
> drop old files
> "scuba19" <scuba19@.discussions.microsoft.com> wrote in message
> news:D954B376-1C4F-449E-B25D-0DF5CDA0FA59@.microsoft.com...
> >I have an SQL server with a number of databses including :
> >
> > Sharepoint and SMS. I would like to move these databases to the D
> > partition and they are currently in the C:\ partition.
> >
> > How can this be done ?
>
>|||What problem are you having with TempDB? Did you move Master and model as
well?
I never tried to do this with system DBs only my own created DBs.
"scuba19" wrote:
> Hi , I found out how to detach but i am having the problem with one
> datbase. A databse that is named tembdb which is 5GB in size
> "jaylou" wrote:
> > The easiest way would be to detach the databases, Move the MDF and LDF files
> > to the new location and re-attach the databases.
> > You can do this all in Enterprise Manager. You can also set the default
> > location to your new location of these databases thru EM Properties of the
> > Server.
> >
> > HTH,
> > Joe
> >
> >
> > "scuba19" wrote:
> >
> > > I have an SQL server with a number of databses including :
> > >
> > > Sharepoint and SMS. I would like to move these databases to the D
> > > partition and they are currently in the C:\ partition.
> > >
> > > How can this be done ?

Location of ReportServer\Styles

Hi,

I have successfully modified HTMLViewer.css to a different version, and using rc:stylesheet = <stylesheet> can view the modified report control bar by running the report via a URL.

However, is it possible to relocate the styles directory from its default location of

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\Styles

so it can reside with our report configurations?

Regards

Kevin.

You can not change the location where RS picks up the styles.

Location of reports?

I cannot find the original copy of a report that is uploaded onto my Report
Server. Where does Reporting Services store the uploaded reports? I need a
physical location so I may copy the .rdl file and edit it.
Is there any other way to copy the report file from inside Reporting
Services?it is in the directory of the report project if you are using VS.NET.
another alternative for the rdl is to select the report properties and
'Update' it (specifying the location of the .rdl - which is what we do for
production here).
Also, you may upload from RM basically anything (it doesn't have to be an
RDL). Let's say for instance that the folder for a department needs a monthly
.XLS for all to work from...
r
"Amon Borland" wrote:
> I cannot find the original copy of a report that is uploaded onto my Report
> Server. Where does Reporting Services store the uploaded reports? I need a
> physical location so I may copy the .rdl file and edit it.
> Is there any other way to copy the report file from inside Reporting
> Services?
>
>|||I was not as complete as I should have been with my answer from post.
if in doubt, look in the ReportServer database (if you used the default name
fom the install) and open the Catalog table. the name and path for the report
are located there.
r
"tutor" wrote:
> it is in the directory of the report project if you are using VS.NET.
> another alternative for the rdl is to select the report properties and
> 'Update' it (specifying the location of the .rdl - which is what we do for
> production here).
> Also, you may upload from RM basically anything (it doesn't have to be an
> RDL). Let's say for instance that the folder for a department needs a monthly
> .XLS for all to work from...
> r
> "Amon Borland" wrote:
> > I cannot find the original copy of a report that is uploaded onto my Report
> > Server. Where does Reporting Services store the uploaded reports? I need a
> > physical location so I may copy the .rdl file and edit it.
> >
> > Is there any other way to copy the report file from inside Reporting
> > Services?
> >
> >
> >|||Amon, the report is stored by RS in the database. It does not exist as a
file. You can use Report Manager to retrieve it (properties of report,
edit).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"tutor" <tutor@.discussions.microsoft.com> wrote in message
news:A431F911-100A-4FCE-852E-D7E2E5CC523E@.microsoft.com...
>I was not as complete as I should have been with my answer from post.
> if in doubt, look in the ReportServer database (if you used the default
> name
> fom the install) and open the Catalog table. the name and path for the
> report
> are located there.
> r
> "tutor" wrote:
>> it is in the directory of the report project if you are using VS.NET.
>> another alternative for the rdl is to select the report properties and
>> 'Update' it (specifying the location of the .rdl - which is what we do
>> for
>> production here).
>> Also, you may upload from RM basically anything (it doesn't have to be an
>> RDL). Let's say for instance that the folder for a department needs a
>> monthly
>> .XLS for all to work from...
>> r
>> "Amon Borland" wrote:
>> > I cannot find the original copy of a report that is uploaded onto my
>> > Report
>> > Server. Where does Reporting Services store the uploaded reports? I
>> > need a
>> > physical location so I may copy the .rdl file and edit it.
>> >
>> > Is there any other way to copy the report file from inside Reporting
>> > Services?
>> >
>> >
>> >sql

Location of Report Files on Server

Does anyone know which directory contains the report (.rdl) files on the SQL
Server Reporting Services server? I'd like to access these files on the
server.
Thank you.There are no rdl files on the server. The process of deploying causes the
rdl to be stored in the database. If you need to retrieve the rdl that was
deployed you can do to report manager, click on the report, properties, edit
and give it a file name to put the rdl into.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Brian P" <BrianP@.discussions.microsoft.com> wrote in message
news:606DD94C-C004-4E30-BD72-DDBB0056C908@.microsoft.com...
> Does anyone know which directory contains the report (.rdl) files on the
> SQL
> Server Reporting Services server? I'd like to access these files on the
> server.
> Thank you.|||Bruce,
Understood. Thanks for the reply.
Brian
"Bruce L-C [MVP]" wrote:
> There are no rdl files on the server. The process of deploying causes the
> rdl to be stored in the database. If you need to retrieve the rdl that was
> deployed you can do to report manager, click on the report, properties, edit
> and give it a file name to put the rdl into.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Brian P" <BrianP@.discussions.microsoft.com> wrote in message
> news:606DD94C-C004-4E30-BD72-DDBB0056C908@.microsoft.com...
> > Does anyone know which directory contains the report (.rdl) files on the
> > SQL
> > Server Reporting Services server? I'd like to access these files on the
> > server.
> >
> > Thank you.
>
>

Location of RDL files?

I'm unable to deploy using Visual Studio and would like to upload my files
manually. I've searched the web server for the existing files and can't find
them. I also searched books online. Any ideas?
ThanksNo rdl files exist on the server. They are all stored in the database.
Deploying a report is more than the report being copied over. To deploy from
outside of VS requires using scripting. Search Books Online for the work
scripting and then open up the samples link.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Leslie" <Leslie@.discussions.microsoft.com> wrote in message
news:58086A07-F1DD-40BE-B0D5-80D3F34891A8@.microsoft.com...
> I'm unable to deploy using Visual Studio and would like to upload my files
> manually. I've searched the web server for the existing files and can't
> find
> them. I also searched books online. Any ideas?
> Thanks|||Thanks for the response. I ftp'd the files over to my server and then
uploaded them using the Report Manager. A little easier than using scripting.
"Bruce L-C [MVP]" wrote:
> No rdl files exist on the server. They are all stored in the database.
> Deploying a report is more than the report being copied over. To deploy from
> outside of VS requires using scripting. Search Books Online for the work
> scripting and then open up the samples link.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Leslie" <Leslie@.discussions.microsoft.com> wrote in message
> news:58086A07-F1DD-40BE-B0D5-80D3F34891A8@.microsoft.com...
> > I'm unable to deploy using Visual Studio and would like to upload my files
> > manually. I've searched the web server for the existing files and can't
> > find
> > them. I also searched books online. Any ideas?
> >
> > Thanks
>
>|||Just an FYI, you can also use the Report Manager to retrieve the rdl if you
ever need to.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Leslie" <Leslie@.discussions.microsoft.com> wrote in message
news:434F327E-9286-47BA-8B6E-6DB079E58461@.microsoft.com...
> Thanks for the response. I ftp'd the files over to my server and then
> uploaded them using the Report Manager. A little easier than using
> scripting.
> "Bruce L-C [MVP]" wrote:
>> No rdl files exist on the server. They are all stored in the database.
>> Deploying a report is more than the report being copied over. To deploy
>> from
>> outside of VS requires using scripting. Search Books Online for the work
>> scripting and then open up the samples link.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Leslie" <Leslie@.discussions.microsoft.com> wrote in message
>> news:58086A07-F1DD-40BE-B0D5-80D3F34891A8@.microsoft.com...
>> > I'm unable to deploy using Visual Studio and would like to upload my
>> > files
>> > manually. I've searched the web server for the existing files and can't
>> > find
>> > them. I also searched books online. Any ideas?
>> >
>> > Thanks
>>

location of rdl files on server

Hi there ,
I am working on SSRS and I just wanted to know where
are the .rdl file stored on the server.I came along this problem as i
was searching a way to make the report content dynamic rather make the
report content customizable .I just wanted to know is there a way to
change rdl files to make them customizable.
thanks.AFAIK, the files are not stored anywhere. When you upload a report, the definition (contents of the
RDL file) is inserted into one or more tables in the report database. I'm not RS expert, though, so
you might want to verify this in an RS forum.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"unixbf" <bondfranco@.gmail.com> wrote in message
news:d2323315-9f7f-44a1-9d32-49795ad3efc2@.v46g2000hsv.googlegroups.com...
> Hi there ,
> I am working on SSRS and I just wanted to know where
> are the .rdl file stored on the server.I came along this problem as i
> was searching a way to make the report content dynamic rather make the
> report content customizable .I just wanted to know is there a way to
> change rdl files to make them customizable.
> thanks.|||Tibor Karaszi wrote:
> AFAIK, the files are not stored anywhere. When you upload a report, the definition (contents of the
> RDL file) is inserted into one or more tables in the report database. I'm not RS expert, though, so
> you might want to verify this in an RS forum.
>
true!

location of rdl files on report server

Hi there ,
I am working on SSRS and I just wanted to know where
are the .rdl file stored on the server.I came along this problem as i
was searching a way to make the report content dynamic rather make the
report content customizable .I just wanted to know is there a way to
change rdl files to make them customizable.
thanks.RDL files are not stored as files on the server. They are stored in the
database. Essentially you have to redeploy the rdl file which you can do by
using webservices. However, you cannot do this for a specific user.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"unixbf" <bondfranco@.gmail.com> wrote in message
news:448b5c16-8146-48b0-a412-8e38d873955d@.v67g2000hse.googlegroups.com...
> Hi there ,
> I am working on SSRS and I just wanted to know where
> are the .rdl file stored on the server.I came along this problem as i
> was searching a way to make the report content dynamic rather make the
> report content customizable .I just wanted to know is there a way to
> change rdl files to make them customizable.
> thanks.

Location of query results (sql 2000)

I have a multi user application running with a query to fill GUI components
(Delphi)
I get a 'share violation' for 'del1.mb' (according to a user). All users run
with the same userid/password against the SQL server. Now I wonder where MS
SQL put the resultset from the query and if access rights to this folder is
the cause of this problem.
Can anyone help?
LanCan you tell what is del1.mb. I feel share violation is because of some
concurrency and locking and not to do with file access.
-Omnibuzz
--
Please post ddls and sample data for your queries and close the thread if
you got the answer for your question.
"Lan" wrote:

> I have a multi user application running with a query to fill GUI component
s
> (Delphi)
> I get a 'share violation' for 'del1.mb' (according to a user). All users r
un
> with the same userid/password against the SQL server. Now I wonder where M
S
> SQL put the resultset from the query and if access rights to this folder i
s
> the cause of this problem.
> Can anyone help?
> Lan|||SQL Server doesn't store the results in a file. It sends the result to the c
lient application. So,
you have to ask this in a Delphi forum.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lan" <Lan@.discussions.microsoft.com> wrote in message
news:4A9D1C6F-7866-4BC8-81E3-C8F88C96FC90@.microsoft.com...
>I have a multi user application running with a query to fill GUI components
> (Delphi)
> I get a 'share violation' for 'del1.mb' (according to a user). All users r
un
> with the same userid/password against the SQL server. Now I wonder where M
S
> SQL put the resultset from the query and if access rights to this folder i
s
> the cause of this problem.
> Can anyone help?
> Lansql

location of ODBC drivers for SQL 2k5 x64 in Win Server 2003 x64 ST

Hi,
I've got Win Server 2003 Standard 64bit edition trying to work with SQL 2005
standard 64bit edition however there is a problem.
I need to locate the ODBC driver in Win Ser.
I know where they are in the 32bit edition but not in the 64bit version.
can anyone help?
Thanks
Olgun.Ucurel@.ccsmedia.comIs there a 64 bit ODBC Driver? I didnt think that there was. You might have
to compile your application in x86 or if you are using SSIS or DTS exec you
can use this post...
http://forums.microsoft.com/MSDN/Sh...603814&SiteID=1
Can you use the OLE DB Driver?
C:\WINDOWS\SysWOW64\odbcad32.exe
uses...
odbc32.dll
and
C:\WINDOWS\System32\odbcad32.exe
uses
odbc32.dll
I am sure others will have some thoughts as well.
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Olgun" <Olgun@.discussions.microsoft.com> wrote in message
news:9BA59FAC-D013-4BF4-9700-A97D71D65545@.microsoft.com...
> Hi,
> I've got Win Server 2003 Standard 64bit edition trying to work with SQL
> 2005
> standard 64bit edition however there is a problem.
> I need to locate the ODBC driver in Win Ser.
> I know where they are in the 32bit edition but not in the 64bit version.
> can anyone help?
> Thanks
> Olgun.Ucurel@.ccsmedia.com|||Olgun wrote:
> Hi,
> I've got Win Server 2003 Standard 64bit edition trying to work with SQL 20
05
> standard 64bit edition however there is a problem.
> I need to locate the ODBC driver in Win Ser.
> I know where they are in the 32bit edition but not in the 64bit version.
> can anyone help?
> Thanks
> Olgun.Ucurel@.ccsmedia.com
As far as I know the ODBC driver is not working on 64 bits Windows. You
could use OLEDB instead, which is working fine.
Regards,
lucm

location of ODBC drivers for SQL 2k5 x64 in Win Server 2003 x64 ST

Hi,
I've got Win Server 2003 Standard 64bit edition trying to work with SQL 2005
standard 64bit edition however there is a problem.
I need to locate the ODBC driver in Win Ser.
I know where they are in the 32bit edition but not in the 64bit version.
can anyone help?
Thanks
Olgun.Ucurel@.ccsmedia.com
Is there a 64 bit ODBC Driver? I didnt think that there was. You might have
to compile your application in x86 or if you are using SSIS or DTS exec you
can use this post...
http://forums.microsoft.com/MSDN/Sho...03814&SiteID=1
Can you use the OLE DB Driver?
C:\WINDOWS\SysWOW64\odbcad32.exe
uses...
odbc32.dll
and
C:\WINDOWS\System32\odbcad32.exe
uses
odbc32.dll
I am sure others will have some thoughts as well.
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Olgun" <Olgun@.discussions.microsoft.com> wrote in message
news:9BA59FAC-D013-4BF4-9700-A97D71D65545@.microsoft.com...
> Hi,
> I've got Win Server 2003 Standard 64bit edition trying to work with SQL
> 2005
> standard 64bit edition however there is a problem.
> I need to locate the ODBC driver in Win Ser.
> I know where they are in the 32bit edition but not in the 64bit version.
> can anyone help?
> Thanks
> Olgun.Ucurel@.ccsmedia.com
|||Olgun wrote:
> Hi,
> I've got Win Server 2003 Standard 64bit edition trying to work with SQL 2005
> standard 64bit edition however there is a problem.
> I need to locate the ODBC driver in Win Ser.
> I know where they are in the 32bit edition but not in the 64bit version.
> can anyone help?
> Thanks
> Olgun.Ucurel@.ccsmedia.com
As far as I know the ODBC driver is not working on 64 bits Windows. You
could use OLEDB instead, which is working fine.
Regards,
lucm