Disaster Recovery Guide

http://technet.microsoft.com/en-us/magazine/ee677581.aspx

Backups

http://msdn.microsoft.com/en-us/library/ms187510(v=SQL.90).aspx

Restoring

http://msdn.microsoft.com/en-us/library/ms177429(v=SQL.90).aspx

Backup Sets (Personally, I prefer to backup to individual files)

http://msdn.microsoft.com/en-us/library/ms191248(v=SQL.90).aspx

"...Before I do this don't I have to set the recovery mode back to full ?..."

You may not need FULL recovery model for your DEV database. That's up to you.

Here's...

Not quite sure what you're looking for. Maybe create a variable called @Body_Temp and build that as you need, then SET @BODY = @BODY_TEMP when you have it built the...

So your Prod backup should be about 114 G

".. Why are you dividing by 128 ?.."

BOL: size, int, Current size of the file, in 8-KB pages.

What recovery model is your database ? How big is the log file ?

What is the result of this ?

USE MyDatabase

GO

SELECT DB_NAME() AS DbName,

name AS...

This is from Books OnLine 'ALTER INDEX ':

ALTER INDEX ALL ON Production.Product

REBUILD WITH (FILLFACTOR = 80, SORT_IN_TEMPDB = ON,

...

I've never used SHUTDOWN. Maybe start the services through Admin tools, or net start mssqlserver from a command prompt ?

The easiest method is to create a Maintenance Plan, with a daily schedule. You can use the "Wizard" to step through the process. You probably should have production databases set...

I think most people prefer to rebuild/reorg based on specific needs of tables and indexes, not all tables and indexes automatically in a maint plan.

I think you could detach the database, rename the extension, then attach.

Always test first and have good backups.

The .BAK backup file should get smaller as the data in the database gets smaller (free space increases), even if the overall size of the .MDF remains the same.

How much...

Well, I'm positive that the answer is "maybe"

Select Import/Export Wizard and see how far you can get.

A little skimpy on details & requirements.

Perhaps the job that updates the subscriber was not running.

No one has mentioned this method:

select * from tableA

then scroll down to the bottom to see how many rows there are

:Whistling::w00t::hehe::-D