Thanks Elliott Whitlow ......Great ...Got same issue ....Ran Almost all blogs....when i running My SSIS package with my credintials its working fine ..when calling it via agent then getting strange...

Thanks Nitin ..Drilled almost all sites there is no such answer for my question.

This is also one good way to deploy the scripts on multi server ...the best way is that ssis ..

Thanks gail ...am looking for it...Now i can see the base table of DMV.

Hi

Bhuvnesh,

You can't restore database from network drive ,it will take lvery long time to restore,because you mentioned in yoir from location is network path,so better move your backup file to...

Hi

Shiv,

Yes you can take a backup all 15 tables which altered .I guess you are working on development environment (Because development guys are keep asking this question ' how to...

Hi

Jone,

SQl server dose not allow for backward compatibility for database you can restore SQL2K Database to SQL2k5 and SQL2K8,but it will not allow you to revert back.Better you can script...

Hi

Mohini,

Check out the licence period of veritas net backup ,because some it will happen when licence got end.

Thanks and regards.

Ashwin v p

HI

Ravi,

There is some thing wrong with your backup command,because error is very clear and you mentioned a wrong file path.Just look in to error out put that says Cannot open...

Hi

Shashi,

as per Brew said na this is lesson for the feture.We have to create good backup stategy on each user and system database,especially the database more than 500 MB should...

------Use this Script

USE [msdb]

GO

/****** Object: Job [GET_Backup_report] Script Date: 07/30/2009 12:58:14 ******/

--------Owner Ashwin v p (ashwin4all1@gmail.com) ...

Hi

Ram,

Use the following script .

Use msdb

SELECT backupset.backup_set_id, backupset.database_name, backupset.type, backupset.backup_finish_date, backupset.backup_size,

...

Hi

All,

Can you tell me which database are you trying to restore master or User database.

Thanks nad regards

Ashwin v p

Hi

All,

You better To use the following command for Getting the instance name.

EXECUTE xp_regread @rootkey='HKEY_LOCAL_MACHINE',

...

Thanks you sir.