For each table you can run the below.

EXEC sp_helpindex N'schema.table';

GO

Thanks

Chris

You should always backup to the local server in the first instance. Once the backup is succesfull this should be copied to another network location where in an ideal...

What operating mode are you running?

If you are running synchronous with manual failover (like i am currently) and mirroring stopped eg the quorum between the principal and the mirror was...

You could use a TSQL task to execute the procedure and return the output parameter into a table. Then have a seperate data flow which copies the data from...

I agree with Gail.

If you don't know what your requirements are or if you have requirements and don't know what to impliment then you need to get someone...

Yes, as long as;

The SQl Server 2005 instance is installed first.

The SQL Server 2005 instance is not SQL Server Express.

Thanks

Chris

I would be interested in the same sort of information for SQL Server 2008 R1.

Thanks

Chris

Thanks GilaMonster, I'm on the case I will post any updates.

Sounds like a memory pressure issue to me.

Have a look at the amount of free VAS (Virtual Address Space).

http://www.eraofdata.com/blog/tag/vas/

Also look at dbcc memorystatus complicated you will need the...

Make sure that the SPN is registered once the server hs been added to the new domain. Often an oversight that I have seen many times.

http://msdn.microsoft.com/en-us/library/ms191153.aspx

Is the SQL server...

To resolve orphaned users search for sp_change_users_login in BOL.

Thanks

Chris

Rather than using Enterprise Manager / Management Studio to script backups / restores i would get used to writing TSQL to do the job not only is it faster but...

I had a similar problem, there is a bug in SQL 2005 whereby if you specify databases to backup and then click on the backup type the selected databases to...

I assume you have connected to the secondary server and are restoring using a UNC path like below?

restore database test from disk = '\\primary server\backups\test.bak'

If you are doing the above...

Can you explain what you mean by command line would TSQL or OSQL be ok?