Gail, new piece of information here: turns out the SQL Server binaries are not installed on this drive, but some of the typical folders are there:

D:\SQL\MSSQL10.MSSQLSERVER\MSSQL

>>...

varchar() or nvarchar()

Yes, there's an option to set the Replicate Schema Changes to false but this means every time a column is added/changed your replication will...

Do you need the procedures replicated as well or just the data in the tables?

I believe your questions are answered here

I don't think you can even buy 1TB SSD???

Tara-1044200 (1/17/2013)

---

On sql 2008 R2 which has 40 CPU's and one SSD drive I want to do the following, please throw your concerns here, appreciate it.

1. creating multiple tempdb data...

If you have successfully restored the DB and everything is up and running (i.e. the DB is ONLINE) there's no harm in deleting the old DB files. If either...

Are you storing the data from all the SQL log files in a table on the Centralized server?

You want to add it to a scheduled job?

USE [msdb]

GO

/****** Object: Job [Automated Email] Script Date: 01/16/2013 15:25:10 ******/

IF EXISTS (SELECT job_id FROM msdb.dbo.sysjobs_view WHERE...

Shrinking the data file will cause fragmentation within the database, and as Gail has stated, regular shrinking in general (both...

ACinKC (1/15/2013)

---

And there's no way to limit...

Gail, I sincerely appreciate your insight. One last point to clarify:

Restore master, that will recreate all the user DBs that the old instance had (providing you left the files...

What you have will work, however as most members of this forum will tell you, it's best to use what Ola Hallengren has already perfected: http://ola.hallengren.com It's proven, accepted, and...

So a workable process would be to:

1. Take full backups of all User DBs and the Master, MSDB, and Model DB

2. Completely uninstall SQL Server

3. Re-install

4. Restore all User...