Think this is a good idea... should work.

keep us posted.

Hi

First find out why some serial numbers "appear" deleted. If u can correct this issue then there is no need to reprocess again.

About reprocessing commands this is my suggestion (maybe...

Hi

get the dba to give you a proper backup.

you can try one more thing - rename the DAT file to .BAK. sometimes this works.

can u tell us what exactly you did.... did not understand clearly ...

hi

i think you can

hi

check the file path of the mdf and ldf files of the database on which you are performing the restore (in the options page).

did u check the overwrite database check...

Hi

Take Transaction Log backups frequently. These can be scheduled according to your needs. This will make sure that your TLog file does not grow too big. Combined with other type...

Hi

Just one thing... I hope you have a very good connection (internet\intranet\other) between you primary and secondary servers...

Hi

i dont think you need to use the "High Availability" (synchronous) SQL Mirroring option, though iam not sure.

Synchronized state means that mirror server is in nearly the same state...

Hi

You have to use dynamic sql for this .

Hi

adding my 2 bits to this...

I have been using varchar(max) for some time now. I have not realy seen any disadvantage(s).

Hi

There are quite a few things to be looked at for getting the hardware specifications right. you would be best served if u go though different sites giving out this...

Hi

In case you cannot use 3rd party tools SQL server DMV's and system tables can give out a fair amount of information.

hi

If by "read only" you mean that the values in this column will change rarely then you may have clustered index on this column. Clustered index works best on...

Vegard Hagen

Thanks for your response.

Regards