One important aspect of this is to identify the sequence of log backups. they must be restored in the order they were taken.

Within your script, You'll need to find out...

Let me know if i am missing something.. I assume you have a 'standby' server for the DR drill (you are not doing drill on prod right?). If you have...

schedule a log backup as soon as you can or else the log file is going to fill up the entire disk leaving the database unsuable..

Since you have never taken...

Jpotucek (9/13/2011)

---

I am simply trying to figure out how to tell my Server Guys how to backup the Server so that when they restore it at DR The SQL Instances...

This is Jeff's query and i've found it very useful. [works with 2k5 and above versions]

SELECT DB_NAME(database_id) AS DatabaseName,

CAST([Name] AS varchar(20)) AS NameofFile,

CAST(physical_name AS varchar(100)) AS PhysicalFile,

type_desc AS FileType,

((size...

pveilleux (9/13/2011)

---

appears as though all the databases only use the primary file group. When they need more space and they can't extent an existing file, they add a new...

Here is a script by Michael that will help you get exact space details from each file of a database.

select

a.FILEID,

[FILE_SIZE_MB] =

convert(decimal(12,2),round(a.size/128.000,2)),

[SPACE_USED_MB] =

convert(decimal(12,2),round(fileproperty(a.name,'SpaceUsed')/128.000,2)),

[FREE_SPACE_MB] =

convert(decimal(12,2),round((a.size-fileproperty(a.name,'SpaceUsed'))/128.000,2)) ,

NAME = left(a.NAME,15),

FILENAME = left(a.FILENAME,30)

from

dbo.sysfiles...

snapshot created by the transaction replication can be applied directly to the subscriber (bypassing distributor). I hope you wish to apply the snapshot to a subscriber which is different from...

you can also have another job that keeps on checking the run status of this job and kills it if it exceeds the threshold. However, regular maintenance of databases are...

System databases (just as user databases) reside on the shared storage. There is a...

if a table is...

You can purge data from the table that you no longer need to reduce...

I agree to the comments mentioned above. However if you really need some books to enhance your existing knowledge, http://www.sqlservercentral.com/Books/ has some free downloadable books.

if your source db had dbreader and dbowner roles for a login, those should come to the destination database as well. If the login is missing on destination server, it'd...

yes. even in transactional replication, this is how you initiatlize the subscriber. all future modifications is read by log reader agent for the published articles.