Viewing 15 posts - 316 through 330 (of 405 total)
As panders suggested run CheckDB. According to the result you might be able to repair the database using checkdb with a repair option.
July 8, 2009 at 6:15 am
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...
July 3, 2009 at 1:07 am
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.
July 3, 2009 at 12:51 am
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%'
July 3, 2009 at 12:32 am
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
July 1, 2009 at 6:48 am
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?
July 1, 2009 at 6:41 am
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...
July 1, 2009 at 6:35 am
Thank you for the suggestion Rene, I will incorporate that in the script.
July 1, 2009 at 5:57 am
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
June 30, 2009 at 11:39 pm
Probably not both
Give datawriter role
This is an article from this site.
http://www.sqlservercentral.com/articles/Security/sqlserversecurityfixeddatabaseroles/1231/
June 30, 2009 at 11:18 pm
You could have used inserted.column_name syntax as Lowell suggested. That would make cleaner readable code.
June 30, 2009 at 11:12 pm
Please give more info on your setup.
Check firewall settings in server.
Use configuration manager to check protocols are configured.
June 30, 2009 at 11:03 pm
Are you doing striped backup?, if yes, please give all the files in restore
June 30, 2009 at 10:37 pm
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...
June 29, 2009 at 6:44 am
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...
June 29, 2009 at 6:12 am
Viewing 15 posts - 316 through 330 (of 405 total)