before moving file please take full backup of that database .

if you are using attached detached for this there may problem .

i had face problem while moving file to another...

hi ,

whenever you restore any database ,that activity related info got stored in

restorehistory table of msdb

plz check with using this

select destination_database_name,USER_NAME,restore_date from restorehistory order by restore_date desc

if ,i...

hey please find below link for auto_close

http://technet.microsoft.com/en-us/library/bb402929.aspx

also in case your missing mdf or ldf missing .

hi please check sqlagent.exe process is running in taskmgr or not.if it is running

then kill sqlagent.exe process .

and try to restart a service.this might work

hi,

you can also find reason in sql server job log.

for that ,you have to give output file in your job .

it will written log and you will exact reason...

please check .

it will work only if you are exec using sysadmin, normal user it won't work.

but if you are running maintainance plan for backup job then it is necessary that intergartion service in running state .

if it not started then your job will fail.

please check sql server integration service is running or not. bcoz maintainace plan is a package.

to execute package ,integration service should be in running state.

please check database mdf and ldf located disk present or not this might reason .

i already face this error such error .it is showing database online in ssms .

bcoz it...

It is possible to give VPN access to SQL Server that currently has one default instance.

please check,how he connecting to sql server .if he using sql client component or taking...

hi,

you will get info in below way..

right click on database go to reports standard reports the backup and restore events

here u will get option successful restore operation...

hi

yes it will break the chain.

t-log backup job failure break t-log chain

below are different reason,

1st if any one taken full backup of same database where t-log...

hi , OS error 5 corrsponds to permissions issue on the file and folder paths.

plz change path & check.

Check for the privileges whenever you get such an error

create new login ,

grant persmission on particular view those they want .

once permission granted ,after that connect sql server with new login ,

exec query sp_helprotect ,

u will get views...

hi ,

you use generate script wizard which is provided in ssms

right cllck on database then tasks you will get generate scripts option.

Using this option u can generate scripts of table...