If you mean 'writing more than one backup file ('striping' the backup), then to my knowledge no. You need to write scripts in order to perform 'striped' backups.

If you mean,...

A stop/restart of SQL Server may be required too. If I remember correctly @@servername will still reflect the old name until this occurs even after the correct SP sequence to...

We probably need a little bit more information in order to potentially assist in a diagnosis of the issue (and hopefully provide a potential solution) ...

1) What were you trying to do ?...

Here's a script we implement as a site standard during initial server build:

 use master

 go

 exec sp_grantlogin 'DOMAIN\sv-sqlserver'    --> each of these domain user accounts

 exec sp_grantlogin 'DOMAIN\sv-sqlagent'     --> are in tyhe local...

thanks for the response on the max number of named instances per server ...

oh by the way here's the most important reason for multiple instances:

 'to compete with Sybase and...

gmail ? why not ...

rudy.komacsar@porterhealth.org

Take a look at this link:

http://support.microsoft.com/kb/304692/EN-US/

I'm curious as to what the 'limit' of instances that can be created on a given physical server is. Please advise (I've just never thiought about this limit !) ...

Tossing about all of the disk numbers, nobody mentioned SAN disk. The reliability and performance of a SAN is unmatched by almost any internal disk configuration for database or dw...

Take a look at this link:

http://support.microsoft.com/?id=290991#4

In the past I've used both methods (EM Maintenance Plans and 'homegrown' scripts). It's pretty much a question of execution time on a per database basis and the amount of...

Be prepared for 'optimzer' culture shock (one of many 'shocks' you will receive from Oracle). SQL Server is a 'cost' based optimizer and Oracle by default is a 'rule' based optimzer'....

The SQL Server optimizer is a 'cost' based optimizer. Basically it will attempt to select the cheapest method (in physical and logical I/O) to satisfy your query (absent any optimizer hints)....

Go to BOL - select the index tab - and enter sp_help.

This may not give you exactly what you want, but it may be a good starting point for individual objects...

One additional point. After changing the 'recovery model' from 'simple' to 'full' you need to perform a full database backup immediately afterwards before any transaction log backups occur to maintain...