Venki508 (2/7/2016)

---

Sorry to disturb you guys...

Just for the confirmation..Iam new to the Sql SERVER database..

So dont we have like this export script in Sql SERVER

expdp username/password schemas=scott exclude=table:"IN('emp','history')" directory=data_pump_dir dumpfile=test.dmp...

Not in...

Luis Cazares (2/8/2016)

---

DB Snapshots use the database as the main source of data and only store pages that get modified. That means that querying against the snapshot is probably going...

so each node has a standalone instance of sql server?

can you supply the scripts you used to apply the read only routing configuration?

:Whistling: I posted the link to that at the beginning of this topic on my very first post :w00t:

At no point does it...

You only need a password for decryption during the backup if the cert is protected...

kenny 40254 (2/8/2016)

---

Also, we ran into a situation over the weekend where something is conflicting the restore jobs on the secondary... we appear to have had a conflicting job that...

take a new backup of the cert

kenny 40254 (2/7/2016)

---

OK, customer dba is fine with me switching recovery model to "full." Per them, their backup scripts will run fine (they are just doing standard backups). They are...

to restore the database to another server you'll need to backup the cert with the private key. You then restore this on the target server, this link details the process

post up a much detail as...

Tis the same thing, db_owner provides the power to backup and restore the database, restore...

As long as it's not a log file growth issue

C Schaefer (2/5/2016)

---

it's much easier to snapshot a few versions of the VM as you build it, so there's no need to start from scratch with re-installs if you...

Again, pausing the cluster node is not recommended. If you happen to have other cluster resources running in this node you'll initiate a failover.

The link posted from Microsoft describes the...