Restoring the replication environment

Is it possible to restoring the master db ? This is to
restore the merge agents settings, without creating the
merge agents again? If any one got an answer for this
please reply asap.
Binoy,
replication agents and the master database are two separate issues. In
master there is sysservers and sysxlogins, both of which are relevant to the
replication setup. However, you are concerned about the merge agent jobs and
parameters which are in msdb (sysjobs, MSagent_profiles, MSagent_parameters
etc). For a good set of details on the replication backup strategy, you can
have a look in BOL for 'replication, backup and restore
operations,Strategies for Backing Up and Restoring Merge Replication'.
HTH,
Paul Ibison

Restoring stored procedure HELP!

Someone accidently deleted some of a stored procedure. Is it possible to
restore just that one whole procedure, or do we have to restore DB and copy
that one store procedure?
Hi
Restore the DB as a different DB on the server and copy it over.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:4A8E8BD3-461B-4175-93B2-37F22B9F6B12@.microsoft.com...
> Someone accidently deleted some of a stored procedure. Is it possible to
> restore just that one whole procedure, or do we have to restore DB and
> copy
> that one store procedure?
|||You can't selectively restore objects. Restore the database elsewhere and
then copy the proc.
It's definitely good practice to keep a separate copy of your SQL source
code, just as you would for any other code in C# or VB. Use a source control
system such as Microsoft SourceSafe.
David Portas
SQL Server MVP
|||restore primary filegroup and copy sp
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Mike" wrote:

> Someone accidently deleted some of a stored procedure. Is it possible to
> restore just that one whole procedure, or do we have to restore DB and copy
> that one store procedure?

Restoring stored procedure HELP!

Someone accidently deleted some of a stored procedure. Is it possible to
restore just that one whole procedure, or do we have to restore DB and copy
that one store procedure?Hi
Restore the DB as a different DB on the server and copy it over.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:4A8E8BD3-461B-4175-93B2-37F22B9F6B12@.microsoft.com...
> Someone accidently deleted some of a stored procedure. Is it possible to
> restore just that one whole procedure, or do we have to restore DB and
> copy
> that one store procedure?|||You can't selectively restore objects. Restore the database elsewhere and
then copy the proc.
It's definitely good practice to keep a separate copy of your SQL source
code, just as you would for any other code in C# or VB. Use a source control
system such as Microsoft SourceSafe.
David Portas
SQL Server MVP
--|||restore primary filegroup and copy sp
--
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Mike" wrote:

> Someone accidently deleted some of a stored procedure. Is it possible to
> restore just that one whole procedure, or do we have to restore DB and cop
y
> that one store procedure?sql

restoring master on sp3 to sp2

I have torestore a master database from sql server 2000 running sp2 onto a
sql server 2000 running sp3. Would it cause any issues? Thanks.
Hi
"sharman" wrote:

> I have torestore a master database from sql server 2000 running sp2 onto a
> sql server 2000 running sp3. Would it cause any issues? Thanks.
Why?
You should have backed up the system database post upgrade (the installation
does tell you to do that!!)
John
|||Hi John,
I think I haven't phrased my question correctly. My question is can I
restore master, model and msdb on sql 2000 sp3 from backups that were backed
up on SQL 2000 SP2?
"John Bell" wrote:

> Hi
> "sharman" wrote:
>
> Why?
> You should have backed up the system database post upgrade (the installation
> does tell you to do that!!)
> John
|||Hi
On Jun 27, 5:14 pm, sharman <shar...@.discussions.microsoft.com> wrote:
> Hi John,
> I think I haven't phrased my question correctly. My question is can I
> restore master, model and msdb on sql 2000 sp3 from backups that were backed
> up on SQL 2000 SP2?
>
> "John Bell" wrote:
>
>
>
> - Show quoted text -
You can try this!! AFAIK there is no guarantee that something has
changed in a service pack or that it will work correctly, therefore it
is best to restore the same level.
John

restoring master on sp3 to sp2

I have torestore a master database from sql server 2000 running sp2 onto a
sql server 2000 running sp3. Would it cause any issues? Thanks.Hi
"sharman" wrote:

> I have torestore a master database from sql server 2000 running sp2 onto a
> sql server 2000 running sp3. Would it cause any issues? Thanks.
Why?
You should have backed up the system database post upgrade (the installation
does tell you to do that!!)
John|||Hi John,
I think I haven't phrased my question correctly. My question is can I
restore master, model and msdb on sql 2000 sp3 from backups that were backed
up on SQL 2000 SP2?
"John Bell" wrote:

> Hi
> "sharman" wrote:
>
> Why?
> You should have backed up the system database post upgrade (the installati
on
> does tell you to do that!!)
> John|||Hi
On Jun 27, 5:14 pm, sharman <shar...@.discussions.microsoft.com> wrote:
> Hi John,
> I think I haven't phrased my question correctly. My question is can I
> restore master, model and msdb on sql 2000 sp3 from backups that were back
ed
> up on SQL 2000 SP2?
>
> "John Bell" wrote:
>
>
>
>
>
> - Show quoted text -
You can try this!! AFAIK there is no guarantee that something has
changed in a service pack or that it will work correctly, therefore it
is best to restore the same level.
John

restoring master on sp3 to sp2

I have torestore a master database from sql server 2000 running sp2 onto a
sql server 2000 running sp3. Would it cause any issues? Thanks.Hi
"sharman" wrote:
> I have torestore a master database from sql server 2000 running sp2 onto a
> sql server 2000 running sp3. Would it cause any issues? Thanks.
Why?
You should have backed up the system database post upgrade (the installation
does tell you to do that!!)
John|||Hi John,
I think I haven't phrased my question correctly. My question is can I
restore master, model and msdb on sql 2000 sp3 from backups that were backed
up on SQL 2000 SP2?
"John Bell" wrote:
> Hi
> "sharman" wrote:
> > I have torestore a master database from sql server 2000 running sp2 onto a
> > sql server 2000 running sp3. Would it cause any issues? Thanks.
> Why?
> You should have backed up the system database post upgrade (the installation
> does tell you to do that!!)
> John|||Hi
On Jun 27, 5:14 pm, sharman <shar...@.discussions.microsoft.com> wrote:
> Hi John,
> I think I haven't phrased my question correctly. My question is can I
> restore master, model and msdb on sql 2000 sp3 from backups that were backed
> up on SQL 2000 SP2?
>
> "John Bell" wrote:
> > Hi
> > "sharman" wrote:
> > > I have torestore a master database from sql server 2000 running sp2 onto a
> > > sql server 2000 running sp3. Would it cause any issues? Thanks.
> > Why?
> > You should have backed up the system database post upgrade (the installation
> > does tell you to do that!!)
> > John- Hide quoted text -
> - Show quoted text -
You can try this!! AFAIK there is no guarantee that something has
changed in a service pack or that it will work correctly, therefore it
is best to restore the same level.
John

restoring from Oracle backup

Hello All,
I have a oracle backup file with the extension .dmp now i am not able to
restore that to SQL Server 2000 database.Can anybody help me with this.
regards
DilishHi,
No, You cant restore the Oracle dump to SQL server due to architectural
differences.
Please use DTS to copy table structure and data from Oracle to SQL server.
Have a look into this link for Oracle to SQL Server migration
http://www.microsoft.com/resources/.../reskit/en-us/p
art2/c0761.mspx
"dilish" <dilish@.covisible.com> wrote in message
news:OvvVSbvEEHA.1376@.TK2MSFTNGP10.phx.gbl...
> Hello All,
> I have a oracle backup file with the extension .dmp now i am not able
to
> restore that to SQL Server 2000 database.Can anybody help me with this.
> regards
> Dilish
>|||There is no way you can restore a backup of an Oracle db directly to SQL =
Server, the internal file structures will be totally different.
You will need to restore the oracle db backup to a system running =
Oracle, and then move the data across using DTS or similar.
MIke John
"dilish" <dilish@.covisible.com> wrote in message =
news:OvvVSbvEEHA.1376@.TK2MSFTNGP10.phx.gbl...
> Hello All,
> I have a oracle backup file with the extension .dmp now i am not =
able to
> restore that to SQL Server 2000 database.Can anybody help me with =
this.
>=20
> regards
> Dilish
>=20
>|||thank u for the information but the here i have a problem that i dont have a
Oracle running on the system.I mean i do not have a Oracle database but just
the backup file.Actually the problem goes like this.
I am having my clients distributed with all running on SQL server
2000 but one client is running on Oracle,I synchronise my central
database,which is again SQL Server 2000 where in i have a separate database
for each client, by simply getting their weekly backups and updating the
central server.Now my new client who is already having an Oracle database
doesnt want to switch to SQL so i am finding it difficult to get his data
onto my server.Means either i will have to go or a separate database,ie
ORACLE or he will have to change to SQL server.
now can u suggest me ways to get this problem solved.
NOTE: the client and Server are not dedicatedly connected.
"dilish" <dilish@.covisible.com> wrote in message
news:OvvVSbvEEHA.1376@.TK2MSFTNGP10.phx.gbl...
> Hello All,
> I have a oracle backup file with the extension .dmp now i am not able
to
> restore that to SQL Server 2000 database.Can anybody help me with this.
> regards
> Dilish
>|||Work with the client to develop an automated export routine from their
database and a corresponding import routine on your system. Oracle provides
import/export features just as SQL Server does.
Alternatively, consider purchasing Oracle, you could then do the migration
from Oracle to SQLServer at your own site.
David Portas
SQL Server MVP
--