Viewing 15 posts - 2,461 through 2,475 (of 3,060 total)
Juan Pablo (7/16/2009)
Try to put the sa account like owner of the job 🙂
:blink: why would you nuke them when an infantry brigade would suffice?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 16, 2009 at 2:22 pm
I can see your DR exercise paid off.
By the way, I think that's a good question for the vendor.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 16, 2009 at 12:42 pm
homebrew01 (7/16/2009)It's running under a windows domain account with sql admin permission.
My money is on a network issue that prevents authentication.
How about using a local account?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 16, 2009 at 12:32 pm
h_maksuda (7/16/2009)
No table is there and no other process is running on it.
:pinch: if TLog is growing something is running there.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 16, 2009 at 11:17 am
ta.bu.shi.da.yu (7/16/2009)Ha! It's funny that their sticky notes deal with exactly the same sort of problems that SQL Server Central contributors face 🙂
Forums are always formus and people are always...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 16, 2009 at 11:02 am
h_maksuda (7/15/2009)
can any one please help me managing my modellog.ldf file.
Is that the model database?... is an application running on model database?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 15, 2009 at 3:14 pm
Most likely Yessoft is looking at table stats rather than actually counting rows.
Are perhaps some table stats out of date?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 15, 2009 at 8:36 am
Amit Khanna (7/15/2009)
It is a user database.
:blink: Are you sure? Look at your original post...
Msg 927, Level 14, State 2 , Line 1
Database 'master' cannot be opened. It is...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 15, 2009 at 8:31 am
Did you follow the whole suggested process?
Here is a step-by-step guide... http://geekswithblogs.net/mskoolaid/archive/2005/12/17/63413.aspx
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 15, 2009 at 8:24 am
vijay1327 (7/15/2009)
thanks for the suggestion. Will start with [2] and see how far I can go.
That's a good starting point.
Once you have your lab in place try to replicate...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 15, 2009 at 8:16 am
MANU (7/14/2009)
Please mail me at manujaidka@gmail.com. I might be able to assist you here.
Are you selling Consulting Services perhaps? 😀
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 14, 2009 at 2:14 pm
winslet (7/13/2009)Do we have any tools to archive the data for all the tables
Yes!... all you need is get hold of B.R.A.I.N. then plan your archive & purge strategy, write...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 13, 2009 at 5:40 am
Luiz (7/8/2009)update tblCustomers set Name='John Kirby' where CustomerID=1 -- allow this
update tblCustomers set Name='John Kirby' -- don't allow this
This is because of people has unrestricted access to that poor affected...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 10, 2009 at 1:38 pm
No silver bullet.
It all depends of business requirements and SLA agreement.
Cheers!
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 10, 2009 at 1:31 pm
The fine art of troubleshooting deadlocks, huh?
You may want to start here http://www.mssqltips.com/tip.asp?tip=1036
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 10, 2009 at 12:40 pm
Viewing 15 posts - 2,461 through 2,475 (of 3,060 total)