CHECKPOINT is a per database operation so you may need to run for multiple databases being attempting to free cache

It is generally taboo to ask a salary range at first interview, it portrays to the prospective employer you're just in it for the cash. Once at a second interview\offer...

To manually fail to the mirror you need to execute

ALTER DATABASE <database name> SET PARTNER FAILOVER

lower the max memory and then raise it again

ananda.murugesan (9/6/2012)

---

If changed another domain account2 at sql service account, SQL Engine service will be working then what will happend at Mirroring part for both server? In this cause, Does...

soccer (9/4/2012)

---

First thing, I added new server into windows cluster.

Secondly, I installed SQL on the new server and added the node into the SQL cluster. The logs indicates clear...

You can do, but i don't use it.

I, and I'm sure many others, create files based on date, much easier to manage.

Please do not forget to rate the article if you found it useful

jheim (9/4/2012)

---

To keep the nodes consistent...is...

yes xp_delete_file was fixed in SP2 but i have seen issues re appear in SP4. I generally use a VB script to manage file removal of backups and logs

So what path\filename did you specify for...

nulls would indicate that although the backup and copy are running no logs are being restored, there can be many different reasons why this happens.

Carefully check the job step history...

zahid_7777 (8/10/2012)

---

Right clicking in the database selecting task then backup, assigning job by selecting script action to job generated by sql server and schedule. Not maintenance plan or writing any...

both instances are partners in the...

What version is your sql server instance at?

The install process between 2005 and 2012 is radically different.