Viewing 15 posts - 2,461 through 2,475 (of 3,061 total)
dba-vb (7/17/2009)
we are moving our production databases to another machine(server). what should i take care(from the sqlserver side)?
Do it twice, a test run then a go-live one.
During the test run...
July 17, 2009 at 7:14 am
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?
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.
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?
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.
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...
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?
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?
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...
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
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...
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? 😀
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...
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...
July 10, 2009 at 1:38 pm
No silver bullet.
It all depends of business requirements and SLA agreement.
Cheers!
July 10, 2009 at 1:31 pm
Viewing 15 posts - 2,461 through 2,475 (of 3,061 total)