Hi,

if you have default security enabled then you see failed logins only. if you have set it to both failed and successful logins, you can see it in the sql...

lol and change...

i think there are no limitations beetwen this two editions in mirroring...

Here the staments you need for mirrored Db's

# Normal Failover (Both Partner are online) for Fallback, Maintenace or Testfailover.

ALTER DATABASE %DBNAME% SET PARTNER FAILOVER

## Emergency Failover (Pricipal offline)

ALTER...

If the Source in allways in the same Instance why not just making a View with the select pointing in the source DB and dont move the data at all?...

First i would change the default database in your configuration to master and then try your connection again. Maybe im wrong but i think you try to connnect to your...

Yes, each change on Datafiles, userrights, tables, views etc. on the prinzipal will also change the objects, rights etc. on the mirror side.

Yes, you have to set up the Db's the same way. Restore the Db's and enable Mirroring.

If you like you can even switch the role and balance the load of...

I think it's because in the time you backup your trn log the first time it writes at the end of your transaction log because the file is...

Hi,

if you start new with oracle it's best to start from scratch.

As a Oracle DBA you have not only the RDBMS to master. You also have Linux, UNIX and...

Hi,

your right. this is because of a missing oracle client installation on your windows server.

If you need more info about connecting to oracle (e.g tnsnames.ora sqlnet.ora etc) ask your...

No, there is a much easier way in SQL Server 2008.

Take a look at this:

http://msdn.microsoft.com/en-us/library/dd392015.aspx

Hi,

if you only want to log the truncate and not preventing from doing so then take a closer look at the auditing options in SQl Server 2008 🙂

Hi,

i would set up a second database and create a db link to access the old data.

maybe it would be better to import in more then one database parallel

regards

ananda.murugesan (4/15/2010)

---

Hi Friends,

New server Details as below as

1. OS windows server 2008 R2 Enterprise Edition

2. SQL SERVER 2008 (SP1) Enterprise Edition

Old server Details as below

1. OS windows 2003...