Database Migration

Hello All,
I need to migrate our databases from one server to another. Now since these
databases have DTS packages/scheduled jobs associated with them, should i
just restore the MSDB database on the target server to recover all settings?
Or is there any alternate way that will be best for my scenario?
Thanks
MannyI would script the job (right-click in EM). And Save DTS packages as files and from those files open
and save them in the new instance.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Manny Chohan" <MannyChohan@.discussions.microsoft.com> wrote in message
news:70B7B8A8-DC90-4C7E-B484-B88EABD23F92@.microsoft.com...
> Hello All,
> I need to migrate our databases from one server to another. Now since these
> databases have DTS packages/scheduled jobs associated with them, should i
> just restore the MSDB database on the target server to recover all settings?
> Or is there any alternate way that will be best for my scenario?
> Thanks
> Manny

Database Logic

I am trying to figure out how to set up this database.

Basically, there are products with their associated fields. Each product can belong to multiple categories, and each category also has subcategories.
So far I have the following, but not sure if this is the best way to set it up...
TABLE Products:
product_id (int)(1-many relationship to product_id in Table Product_Category)
sku (int)
description
price

TABLE Category
category_id (int)(1-many relationship to category_id in Table Product_Category)
name

TABLE SubCategory
subcategory_id (int)(1-many relationship to subcategory_id in Table Product_Category)
category_id (int)
name

TABLE Product_Category
prodcat_id (int)
product_id (int)(many-1 relationship to product_id in Table Products)
category_id (int)(many-1 relationship to category_id in Table Category)
subcategory_id (int)(many-1 relationship to subcategory_id in Table SubCategory)

Thanks,
Mick

TABLE Products:
product_id (int)(1-many relationship to product_id in Table Product_Category)
sku (int)
description
price

TABLE Categories
category_id (int)(1-many relationship to category_id in Table Product_Category)
parent (int) (1-1 relationship with Category)
name

TABLE Product_Categories
prodcat_id (int)
product_id (int)(many-1 relationship to product_id in Table Products)
category_id (int)(many-1 relationship to category_id in Table Category)

Categories table would look like:

1,0,furnature

2,1,chairs

3,1,tables

4,0,automobiles

5,4,pickups

6,4,minivans

You can then also (If you need/want)

7,6,buick

Which would then be Category automobiles, Sub-Category minivans, Sub-Sub-Category buick

database log file size problem!

Somehow my database log has (ldf file) has grown to over 60GB! and the
database it is associated with is only 32MB, how can I compress this file?
it seems to be getting larger by the hour and now disk space is running
out.. thanks!Hi
Look in books online about "recovery models". You probably have the DB set
to Full Recovery and are not making transaction log backups.
Regards
Mike
"Brian Henry" wrote:

> Somehow my database log has (ldf file) has grown to over 60GB! and the
> database it is associated with is only 32MB, how can I compress this file?
> it seems to be getting larger by the hour and now disk space is running
> out.. thanks!
>
>|||How to stop the transaction log of a SQL Server database from growing
unexpectedly
http://support.microsoft.com/?kbid=873235
AMB
"Brian Henry" wrote:

> Somehow my database log has (ldf file) has grown to over 60GB! and the
> database it is associated with is only 32MB, how can I compress this file?
> it seems to be getting larger by the hour and now disk space is running
> out.. thanks!
>
>