great, thats good news

so ifeverything works fine then whats the problem?

After taking up the backup, I verify my backups using :

RESTORE VERIFYONLY FROM DISK ='C:\YourBackupfile.bak'

Merry Christmas everyone:D

If you are looking for a method to run your BI packages you can do that in command prompt dtexec.exe utility

Try this:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YOUR_VIEW]') and OBJECTPROPERTY(id, N'IsView') = 1)

drop view [dbo].[Your_VIEW]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Yout_Table]') and OBJECTPROPERTY(id, N'IsUserTable')...

There would be little effect in performance but no one will be kicked off or users can still be logged on to the app with not much affect. Actual time...

Does exec sp_change_users_login 'Report' return the users you are seeing orphaned

There is no way u can recover single table. You do have to recover whole database using ur full backup then get the diff backup restore and from the recovered...

thanks for bringing up that. good tips

One way will be to free some space on your drive where your files (.mdf or .ndf or .ldf)are which are taking up all the disk space.

When u have...

But that option might give u error if u have constraints set up on ur destination database.There is very high risk of breaking things there because if u r just...

It can't be done. Backup-restore is the option.

Can u use RESTORE FILELISTONLY FROM DISK = ' C:\ yourBackUpCopy.bak'

and give me the results of the query

Thats a transaction log backup. Take up full backup of ur database and then restore that. Transaction backups r of no use anyways if u dont have full backup and...