Thanks to every one for your replies

with all inputs and googling finally i am end up with doing this

--Source DB: ScourceDB

--Destination DB: DesDB [this DesDB is only...

Thanks for the quick reply

but i want this backup task should be scheduled, so i cant use wizard. that is the reason that i am looking to write some script...

Lowell,

Thanks for your reply. it is a great input to me to work on redesign the Data Model. even i do like having the table names fully readable and understandable....

Yeah, i got ii.

thank you,

Hi,

could you please help me out, how can restore only the full backup from the same file which is also having differential backup

Thank You all,

after all your inputs i am sticking with 3 tables and a view to populate the Models.

There is another argument that is going on my team , need...

Hi Steve,

Could you please explain in more details.

as Ian Scarlett said the bellow two are true

A Market can have many Products, but a Product can be in only one...

Hi Ten Centuries

Could please tell me how this process can be configure or track in SQL 2008

Hi ALL,

Thanks for your replies.

I dont have any particular requirement to check the log on periodically. I only want to check the log when some thing goes wrong.

if this is...

Can any one please provide the information on this

Thank You

when i check the free space it is saying 99% is free space out of 32GB for log file

how can i solve this problem

YEAH,

Exactly i was thinking in the same way, using the default values.

I am just waiting for the default values for those fields from client.

Thanks every one for your responses.

Thanks for your reply,

Yeah as you mentioned i have read some article on 2005 , as this is an issue for indexing & Null .

But my major problem is there...

I have two agents jobs for backups, sunday full bkp and rest of the days differential bkp, if i do this 'Shrink' task, will it have any impact on my...

Hi PS,

Here the details

My Actual BKP file - 10.2GB

ldf - 32GB

mdf - 13GB

My BKP agent jobs script is

Full Bkp Script:

===========

SET @filename = ''E:\Backup\DB_Date.bkp''

BACKUP DATABASE [DB]

TO DISK = @filename

WITH INIT, NOUNLOAD,...