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.

Located databases no longer used.

I’m looking to locate databases that have not been written to or accessed for
a specified period of time; we are looking to locate databases that are not
used anymore and clean house. Is there a system table or stored procedure to
access this information? Thank you in advance for you assistance.
Pauly C
No there is not. Your best bet is to run a continuous trace filtered on the
particular db(s) and see if anything accesses them.
Andrew J. Kelly SQL MVP
"Pauly C" <paulysc@.optonline.net> wrote in message
news:04BD4AED-F586-4686-ADBB-0AD86A4EEF90@.microsoft.com...
> I'm looking to locate databases that have not been written to or accessed
> for
> a specified period of time; we are looking to locate databases that are
> not
> used anymore and clean house. Is there a system table or stored procedure
> to
> access this information? Thank you in advance for you assistance.
> Pauly C
>
|||Bummer, Thanks Andy. Tony B say's hello.
Pauly C
"Andrew J. Kelly" wrote:

> No there is not. Your best bet is to run a continuous trace filtered on the
> particular db(s) and see if anything accesses them.
> --
> Andrew J. Kelly SQL MVP
>
> "Pauly C" <paulysc@.optonline.net> wrote in message
> news:04BD4AED-F586-4686-ADBB-0AD86A4EEF90@.microsoft.com...
>
>
|||Didn't even realize that was you<g>. Unfortunately the answer is still
no<g>... Everyone wants that feature though.
Andrew J. Kelly SQL MVP
"Pauly C" <paulysc@.optonline.net> wrote in message
news:A5BDC793-6A72-4F0B-9891-025DC99D927C@.microsoft.com...[vbcol=seagreen]
> Bummer, Thanks Andy. Tony B say's hello.
> Pauly C
> "Andrew J. Kelly" wrote:

Localhost Vs Servername in Connection string of SQL Server 2000

Hi,
Do you know how ADO will behave based upon the servername that is
specified in the connection string of SQL Server 2000? When does it
work with localhost and when does it not? Is it documented that this is
the expected behavior?
Thanks,
Regards,
PramodWith SQL Server2000 or older, the server name is "Compuername" or "(local)",
(plus "\instanceName" if necessary). It is not "localhost", which is used to
refer to web server, not SQL Server (I may be wrong on this: you can use
"localhost' for SQL Server 2005, though).
<ipramod@.gmail.com> wrote in message
news:1164191517.623131.63680@.e3g2000cwe.googlegroups.com...
> Hi,
> Do you know how ADO will behave based upon the servername that is
> specified in the connection string of SQL Server 2000? When does it
> work with localhost and when does it not? Is it documented that this is
> the expected behavior?
> Thanks,
> Regards,
> Pramod
>|||Hi,
Is there any difference when we use (local) or localhost in connection
strings of SQL Server 2000 ?
Thanks,
Pramod
Norman Yuan wrote:
> With SQL Server2000 or older, the server name is "Compuername" or "(local)",
> (plus "\instanceName" if necessary). It is not "localhost", which is used to
> refer to web server, not SQL Server (I may be wrong on this: you can use
> "localhost' for SQL Server 2005, though).
> <ipramod@.gmail.com> wrote in message
> news:1164191517.623131.63680@.e3g2000cwe.googlegroups.com...
> > Hi,
> >
> > Do you know how ADO will behave based upon the servername that is
> > specified in the connection string of SQL Server 2000? When does it
> > work with localhost and when does it not? Is it documented that this is
> > the expected behavior?
> >
> > Thanks,
> > Regards,
> > Pramod
> >

local database in c#

Hi,

I want to create a database in a path specified by the user at runtime when he selects a menu item like File/New. My preference is to not require the user to run an sql server on his machine to run my application. All my searches on the web for this keep directing me to the code that creates a database on an sql server but I don't want that. I want the application to create the database at runtime at a place where the user chooses. I would appreciate either a snippet of code or a link to somewhere helpful please.

Hi,

MS Access is the solution for u. It does not require any extra files to work. It just need MDAC to be installed and it's shipped with Windows.

All u have to do is to create ure database with all tables, views,... with no data. Ship the empty database with ure application and when the user wants to create a new database u just copy the empty database to the user location.

HTH.

Hayder Marzouk

|||Thanks Hayder.

If there is a way to do this with a local sql database, I would appreciate some sample code to see how to do it.
|||

Hi,

You may create a T-SQL script and then run the script to create a database.

Move from C# express forum to Sql server forum.

Thanks

|||

Not within your specified 'requirements'

My preference is to not require the user to run an sql server on his machine to run my application.

A 'Local' sql database will require that the user run or have access to a SQL Server.

As Hayder mentioned, an Access database is an excellent option and does not require that the user have access to, or install a SQL Server.