Might not be a bad idea to setup...

I'm curious has your database full backups taken longer to backup after removing/deleting all that data? We deleted Terabytes of data (though we have less data our backups take...

You would need to install...

(edit: since I have no image - the msg I receive is "An object (User) with the following name cannot be found. "Scott" (which is my Windows login). Check the...

TecNQ (5/8/2013)

---

Thank you for your reply.

However, this does not answer my question exactly.

What I am after is a way to say to the database, ".. at 6pm tonight I want...

SQL Show (5/8/2013)

---

What is the auto growth of your lDF file

I am about to blame the number of VLF files in your database. Your Purge might be adding lots of...

You can also test the if the bottleneck is coming from the backup disk or your data disk.

Backup to nul to test backup read speed, if it doesn't change (or...

dmcquilken (5/8/2013)

---

andriancruz (5/31/2010)

---

Hi Everyone,

I'm using CmdExec to call VB Application to extract records. The application is running fine. But when I put into Jobs the status is always executing. Anyone...

My question:

Is it possible to schedule a nightly process to disconnect all live connections to a database? I am asking this because sometime we need to detach databases for maintenance...

databoy (5/7/2013)

---

I have to convert a named instance to default instance before that i have taken backups of all databases including reportserver and reportservertempdb.

i have uninstalled the named instance...

Sqlism (5/7/2013)

---

what all the firewall changes should be done to access named sql server instance that is running on port number 6000,

My requiremenet is all the users should be able...

Thanks for mentioning

When you delete a large or very large numberr of rows at one time, SQL Server defers the actual deletes. The next time a page with deleted r0w(s)...

Thanks Steve for reply!

The full backup isn't backing up the log, unless the index rebuild is running while the full backup is running. Then it will catch items changed...

1. If the transaction log is not backed up after the index rebuild or purge and before the the log shrink,

the shrink will likely fail, because there will be more...

I would imagine backup process "really" depends on your organization's requirements.

Backup the database with "Checksum" (Just to be safe using checksum)

Then using a Restore Verify Only

and using...