I'd ask how much data changes? And how often? You could use transactional replication, either on a schedule or continuous, to move data across. That would avoid the downtime with...

Thinking like a CIO/CEO/or manager should change your job. Think about their point of view, their needs, etc. and it will help you. You don't have to agree with them,...

Why 3 tables? Isn't market in the Market_Product table? Can't you join those 2 tables?

I miss anything? Just cranky old guys and gals complaining?

The post is a little self promotion, but I'm more willing to tolerate authors promoting themselves than companies. Might be a...

sys.objects will contain the name of the index or table, but not the details. If you want more information about those, sys.indexes, or sys.columns will help. There are lots of...

You can use schemas to do this. Filegroups are used for performance separation, not logical separation.

Also, if you create two roles, you can assign rights as needed to each group....

sys.objects can help you. It has all objects in the system in it (http://msdn.microsoft.com/en-us/library/ms190324%28SQL.90%29.aspx)

There isn't any (big) advantage I can see to appending to disk. However there are disadvantages. As Grant mentioned, you can't easily see what's inside. But more so there's a...

You can't do this by Filegroup since a filegroup is a physical structure. The user and tables are logical structures.

also, what about indexes? You don't necessarily have indexes on the...

Mark's procedure will work. It's how I typically restore things for one-off situations. However, I'd recommend you try scripting the restore. You can set up the restore, and then click...

Rudy, a good list and thanks for adding it in,

BTW, you're gen X, like me

If you restore master to a different windows server, at first it will not be visible on the network. It will be responding to the old name. sp_dropserver, sp_addserver will...

The location for the master db is a parameter in services. You can fix it for the service.

Check the Windows Event log for the reason the service won't start.

The same thing can happen with a rouge admin in SQL. If you do not trust and audit your admins, you are in trouble.