Thanks to both Jeff for excellent points on SAN.

1)

On the database mirror + database snapshot option, are you referring to these 2 technologies:

http://technet.microsoft.com/en-us/library/cc917680.aspx

http://msdn.microsoft.com/en-us/library/ms175158%28SQL.90%29.aspx

If so, won't the Original Database be...

Thanks for your inputs. That makes it clear.

Also the examples were helpful, GSquared.

Perfect!

Thanks.

I changed the settings through Alter Database commands. But when I see through SSMS or sys.database_files, it is not reflected. Growth is zero in sys.database_files

Bru

I had sent my post before seeing yours. Thanks.

I had only 2 files to deal with. It will be interesting to check out the 3 file option sometime, to learn...

but if Point-time-is not important for a database (as per business rules, in a crisis), then are there any other benefits to do a FULL recovery model?

shrink and delete worked. Thanks Bru.

After I read that 'EMPTYFILE option migrates all data from the specified file to other files in the same filegroup' from http://msdn.microsoft.com/en-us/library/aa258824%28SQL.80%29.aspx, I was assured and did the shrink and...

ramuvanparti

What would be the difference to copy from the original database vs the snapshot database?

thx

dan

homebrew01

It is a good option to know. Thanks for telling abt Redgate.

ChiragNS,

Thanks for the 2 points. I am not going to try the 'page restore' method, but good to be...

ok. I shows that it holds the same indexes as in the second file. (used sysfiles & sysfilegroups to see that). But the second file is 5GB, so I feel...

Gail

Thx for ur input on log vs data file usage, when more than 1 file is in use.

I have 2 data files. One is 201 MB full. The other one...

sure enough.. it is a different logical name.

There is already 201 MB in it. What could it be? Can I see what data is inside?

Bru

I am not in my office now, but will let you know as soon I see it if it is the same logical name or not. I thought so, but...

on couple of the SQL servers, 'No Paging File' is selected for all the drives.

Is that ok?