you will need to know the password used to protect the certificate from server A in order to import it into server B.

For security I suggest you then re-encrypt the...

If I understand your question correctly you cannot BACKUP a database to a time in the past, but you can RESTORE it to apoint in time in the past.

You need...

once you specify an include to limit the profiler to just the databases you want, you don't have to specify an exclude as well.

no problem. It is an issue with constantly overwriting the same file, it is possible that sooner or later they can get corrupted, so longer term if you have the...

I would expect deleting the current file via explorer so that the backup is creating a fresh file to work.

Copy or move the existing file elsewhere to be safe. Have...

allamiro (1/6/2016)

---

Never use maintenance plans for reindexing -

I was wondering why ? if the option is there and we have one database why maintenance plan wont suffice for that operation...

allamiro (1/6/2016)

---

Ed Wagner (1/6/2016)

---

Hugo Kornelis (1/6/2016)

---

The statement "doesn't work or doesn't work well" is invalid.

But if you ask which is better, then my guess is that 99% of the experts...

.......and just as important set the growth factor sensibly as well, do not accept the default 10%.

thats an 'it depends' question which is dependant on size of the mdf file, throughput, recovery mode and frequency of log backups if not in simple mode.

A very rough guide...

Copy the production certificate over and use this to restore the prod database on dev. Then re-encrypt the restored database with the dev certificate, and drop the prod certificate.

no one...

Generally, only applu CUs if you have encountered the issue it resolves, and that is certainly the case for hotfixes.

So you have two valid choices,

a) apply SP4 followed by...

all you need to do is change the service account password to its new value via SQL configuration manager (it MUST be done via this tool) and then either wait...

during a failover where you are using log-shipping and you want to swap the roles of the servers

there is a quick fix to the report builder problem which we have used successfully here so I am happy to recommend it. Basically install 2008R2 RTM then go straight...

resource database contains metadata on the instance. Back it up using file explorer copy and paste. It only changes when the instance is patched so only needs to be copied...