You should have created a new filegroup and move some tables to it.

By moving the clustered indexes to the new filegroup the tables will be moved.And for tables which dont...

Yes... u r correct...

I did'nt understand your question completely...

But you can know what are the jobs which are using particular databases.

Use msdb

select * from sysjobsteps

you have a column database_name in this table.

Yes ...go with Log shipping.

Specify the logbackup restoration latency for 2 hrs in the log shipping configuration.And also to use the database for reporting purposes keep it in standby/readonly mode...

Restore the backup with a different database name on the same server or different server.Then use import wizard ,which will create the table as well as move the data to...

The log backup files will be of varying sizes.If heavy DML operations is performed or any index rebuild happens the log backup files increases heavily and thus variation is there...

In read committed isolation level(its the default) uncommitted transactions will not be returned.

In read uncommitted(least isolation level) you can get the dirty reads,uncommitted data.

Since you did'nt mention any isolation level...

You configured it well.No issues.

Log shipping has two options one is stand-by and the other is norecovery mode for the secondary database.

When you select the first option,the database will be...

SQL Profiler is the one you can use.

All the maintenance plans were scheduled at the same time(saturday...

Backups are of three types.

Full backup

Differential backup

Transactional log backup

The thrid one has the .trn extension.

Please refer Books Online for types of backups.I think you should go through it.

You will restore the .bak file which was taken recently.In addition to...

How can one add the column without knowing the table name.

Anyway,you can query the syscolumns system table order by Created_date desc.Get the object_id from this and query the sysobjects table...

A database is to be preserved everyday.That is one of the main task of...

Venu,

.bak file cannot be opened.It is the file which can be restored in sql server as a database.

What info did u mean?

Once you...