What happens? Are there any errors? We need more information to further troubleshoot this issue. What's your code? Have you run a SQL Trace (or XE)...

Go into SSCM and double check to make sure the SQL Server service is set with automatic startup. It sounds a little like the service is just set for manual...

Hey, Colleen!!! So I tried that...

There are a lot of things wrong with your last post. First, variable names are declared with an 'at' sign (@). Executing this code:

DECLARE example varchar(8)

...results in the...

Your best bet here would be to script out the database (schema and data, if you so choose) on your source 2008 R2 instance, and run the script against your...

Clustered indexes are the actual table data (hence why you can only have one clustered index per table). A nonclustered index will have key column and non key column data...

How much space is free in your data file? Use the below query (version-controlled copy here) to find out this information:

use YourDatabase;

go

;with DatabaseFileInfo as

(

select

db_name(database_id) as database_name,

name as db_file_name,

size...

backup database YourDatabaseName

to disk = 'C:\YourBackupDir\YourDiffBackup.bak'

with differential;

go

SQL Server does not support incremental backups. A differential backup would be capturing data that has changed since the last full backup. No matter how many diff backups...

If you want to modify this, you can run the below T-SQL. The first changes the max rows to 2000, max rows per job to 200 (as opposed to...

What's the instance name?

Can you show us the exact Job details/commands?

Is the SQL Server service actually started? Check this through SQL Server Configuration Manager. The error you are receiving is not a credentials issue, but a connection problem....

Jeff Moden (7/2/2012)

---

Thomas Stringer (7/2/2012)

---

Jeff Moden (7/2/2012)

---

Thanks guys... I understand why some of us might do such a thing but I really want to know why the OP wants to...

Jeff Moden (7/2/2012)

---

Thanks guys... I understand why some of us might do such a thing but I really want to know why the OP wants to do it. If...