I'll throw my 2 cents in.

Create an instance of SQL Server Express Edition in a version equal to or greater than the one used to take the backup. If...

My suggestion:

Create a .bat batch file on a computer and create a SQLCMD line for each server instance that you need to run it on.

For instance:

sqlcmd -S ServerName1\SQLEXPRESS -E -i...

It is certainly no easy task, but basically you want to create Views that restrict the rows that are returned, such as the following:

--SQL Server example

CREATE VIEW vw_MySales

AS

SELECT * FROM...

Of course, then comes the debate of what fill factor to use on the rebuild......

Totally agree. Page count is the main one other than avg frag %.

I use > 30% and > 50 pages to rebuild. Less on either just gets a...

Colin is correct. HA and DR are two totally different animals. It is my opinion that you should first discuss with management and business units to determine their...

Oh well. Here is the code. Sorry for putting it here....

USE master

GO

CREATE DATABASE AuditTest

GO

USE AuditTest

GO

CREATE TABLE Customer

(CustID int IDENTITYNOT NULL

CONSTRAINT PK_Customer_On_CustID PRIMARY KEY CLUSTERED,

CustFNamevarchar(20)NULL,

CustMNamevarchar(35)NULL,

CustLNamevarchar(35)NULL,

CurrRecbitNOT NULLDEFAULT (1),

LCHostvarchar(50)NOT NULLDEFAULT HOST_NAME(),

LCUservarchar(50)NOT...

I have attached examples of how I do them. We use them for accountability, and for troubleshooting ("why is it THIS value???"). I have a mechanism embedded that...

Forgot to mention one detail. I copy from server to Data Domain, so the server's NIC is a GB NIC, and I'm slowed by the network link from those...

aferro:

I would have a bit of anxiety over that, also! I do dozens of databases, the biggest is around 120 GB, and on down to 30 mb or so.

One...

I think this may be what you are looking for. It is a script I wrote to do Instance Security Audit documentation. This is the latest version. ...

Here is a simple example.

First file is the .sql script. It is invoked using SQLCMD in a batch file. Create one of these .sql files for each of...

We use Data Domain for backup archiving. It is 1/2 mile away at another site.

I back up all my databases to the actual server that it resides on. ...

Here is a quick script to see the last backup for each database on the server. Gives file name (so you know where they are going), whether the database...

Just a thought, I would also keep and stash away a copy of the associated logins scripted out using the sp_help_revlogin procedure. That way, you can reinstall the database...