As panders suggested run CheckDB. According to the result you might be able to repair the database using checkdb with a repair option.

Pls Ignore my message. I did not notice the path you used.

What Chandra said is correct. The problem is with the share name. After that you sort out the rights...

You are probably having rights problem.

What is your service start up account? It should preferably be domain account and should have write access to the path.

for configured

use master

select * from sysperfinfo where counter_name like '%target server memory%'

currently used

use master

select * from sysperfinfo where counter_name like '%total server memory%'

Dean,

See whether this applies to you

http://support.microsoft.com/kb/324432

There is a script in the article to see whether the shrink fails because of BLOBs in your DB

Can you please give a little more info on what you are trying to achieve?

@store='Exec ('+@sql+')'

The above is not what you are looking for. Is it?

Have some doubts here. You have cleared 80 GB of data.

What is your physical file size now?

BOL: DBCC SHRINKFILE does not shrink a file past the size needed to store...

Thank you for the suggestion Rene, I will incorporate that in the script.

Do you have ssms on any other client? It looks like problem with service pack only. If you have tools installed on your server, try accessing from the server itself

Probably not both

Give datawriter role

This is an article from this site.

http://www.sqlservercentral.com/articles/Security/sqlserversecurityfixeddatabaseroles/1231/

You could have used inserted.column_name syntax as Lowell suggested. That would make cleaner readable code.

Please give more info on your setup.

Check firewall settings in server.

Use configuration manager to check protocols are configured.

Are you doing striped backup?, if yes, please give all the files in restore

Venu,

As Gail Shaw said, you should include full backup in your backup plan.

In case of disaster you need to restore latest full backup (with no recovery option), then restore...

Venu,

If you don't take full backup for a long time, then the size of full backup will increase and become as big as full backup itself.

Since differential backup will only...