Viewing 8 posts - 1 through 8 (of 8 total)
Thanks for the assistance. last week I ran your steps - well - these steps
run dbcc DBCC SHRINKDATABASE
then DBCC UPDATEUSAGE
then exec sp_helpdb 'DbName'
and all was well - I cleared up...
October 24, 2006 at 2:14 pm
Thanks. Since no one has access to this database but myself - then there will be no unsafe entries after the first backup - am I correct - so one...
October 17, 2006 at 10:10 am
Thanks. Dumb question - why the 2 backups? and what does then exec sp_helpdb 'DbName' do?
Also does this take a major hit on performance on my SQL server - the...
October 17, 2006 at 8:50 am
Thanks. If I want it to never run again - can I just delete it or is there anythingi special I need to do?
I saw in Query Analzer that it...
May 16, 2006 at 1:38 pm
Thanks. The mirroring in this article so far has been helpful.
Next question - it mentions setting up a trigger - once you apply a trigger how would you stop...
May 16, 2006 at 12:58 pm
Thanks. My goal is to see when and by who records from on table in the database were deleted and/or changed.
Any ideas are welcome - I will also search for the...
May 15, 2006 at 7:10 pm
Viewing 8 posts - 1 through 8 (of 8 total)