If the database size is small you can also afford to create snapshot 3 or 4 times a day but if the size of your database is that big obviosly...

you can only read and restore the database if you are using STAND BY Restore option. There are pros and cons to this recovery method. google it out for more...

backup drive is included in SQL Server Group in cluster administrator.

your welcome..

sql svr 2005

http://www.sqlservercentral.com/articles/Administration/2960/

sql svr 2008

http://www.sqlservercentral.com/articles/SQL+Server+2008/63491/

It all depends on your exisiting infrastructure. This should...

I agree with Scott's explanation as well.

With logshipping experience i have, i'll advice to use windows or sql server cluster IPs (or machine names or UNCs with cluster name)...

Backup job is running thourgh sql...

you can cast or convert the data in text format after adding additional text.

Vicki, can you please tell whats the reason behind storing trademark into a table, whats the business reason for it?

Thanks

instead of using a cursor try this example code below.

drop table finaltbl

drop table comments

create table comments

(id varchar(10),

comm1 varchar(50),

comm2 varchar(50))

insert into comments values(1, 'COM1', 'COM2')

insert into comments values(1, 'COM3', 'COM4')

insert into...

just for curiosity, which approach you followed, Tally table or UDF and why you followed it?

My recommendation is to use one db file. further you can use filegroups if you want.

Even we follow same technique as of Jeffery of having backup disks cluster resources in sql server cluster group rather than creating seperate group. I also faced this problem of...

check this out

http://support.microsoft.com/kb/224967

http://204.9.76.233/Community/forums/p/2606/153808.aspx

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

http://sql-server-performance.com/Community/forums/t/28062.aspx