is this about replication or clustering? can you elaborate more?

you may want to split the text on comma and then removing single quotes.

see here how to write split function.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50648

do you mean to say when you restore database, sp, triggers etc is restored as well along with data?

if thats what you mean then yes. a db copy of the...

Differential backups are independent of other differential backups and depend on the previous full backup.

Since log truncation is waiting on replication, either u create and drop the replication (as suggested by Gail earlier) or you keep on running sp_repldone at intervals. Log backups will...

PhilipC (9/15/2011)

---

Thanks for your help guys.

Turned out he wanted multiple sql instances installed in the same resource group. I didn't think this was even possible. Am I missing something here,...

madhuu1905 (9/15/2011)

---

Hi All,

Actually my requirement is we have 10 instances in QA in same domain, if we create login on one instance then it should be created on other 9...

forsqlserver (9/15/2011)

---

We are expecting that file has created and somebody has deleted..Will it not break the sequence chain if I again issue the differential backup...We take the differential backup on...

The link posted above contains an extremely useful set of scripts suitable for regular maintainance.

However, since you are trying to learn things, you should write your own scripts and...

You should be able to open and check your database. That's why we have the standby...

Can you specify V1 in more detail. What are you referring to by specifying V1 as Network name?

If V1 and V2 are physical nodes which form the cluster, whenever you install a sql server, it'll have to be identified by it's own name (virtual server or resource...

in the above example, V1 and V2 will be the resource name (or the instance name or the virtual server name).

For named instance, it'll be V1\V1 and V2\V2

and...

Here is the clustering whitepaper.

http://www.microsoft.com/download/en/details.aspx?id=19736

In a cluster, when you install a sql server instance, you put all resources (db engine, sql server agent, disks, IP etc) in a resource group....

DSmith11 (9/14/2011)

---

In regard to clustering and the virtual server name. If you have multiple instances on the cluster, do you have to specify a different Virtual Name for each instance...