Viewing 15 posts - 17,086 through 17,100 (of 39,903 total)
You create a login and user on the source system.
You then migrate that login to the new system (the user will come through log shipping) using the same SPID.
This should...
January 13, 2011 at 3:21 pm
I have heard of upgrades being done that have literally been done with shipping a SAN through Fed Ex for large scale migrations.
These days I'd use Michael's advice. I'd actually...
January 13, 2011 at 3:18 pm
Backup does nothing to the transaction logs. Not sure what you mean by "reorganize" here, but a backup doesn't affect t-logs.
The thing is you database file and your external files...
January 13, 2011 at 3:15 pm
January 13, 2011 at 3:10 pm
Luke L (1/13/2011)
January 13, 2011 at 2:28 pm
You cannot make changes to a db in standby mode.
January 13, 2011 at 2:20 pm
I like Geoff's advice. Do not overwrite files. You'll overwrite the one that you need in a disaster situation.
Write a new file every time you do a full backup, and...
January 13, 2011 at 11:00 am
Stefan Krzywicki (1/13/2011)
January 13, 2011 at 10:53 am
The author is an open source person, so I'm not surprised that Oracle/SQL Server aren't on there. I assume they qualify as RDBMSes, just like MySQL 😎
January 13, 2011 at 10:49 am
Tom Garth (1/13/2011)
A primary measure of any application should be it's ability for "GRACEFUL DEGRADATION".
Too true, and too often I see developers that don't ever expect a query to fail...
January 13, 2011 at 10:48 am
john.richter (1/13/2011)
...With cloud storage it is likely that even the rough calculation of what I call an "insecurity quotient" may be impossible for a customer to know.
...
You...
January 13, 2011 at 10:43 am
If you get that message, then somewhere in there you have a pattern that isn't being caught or isn't handled well. The Charindex doesn't find something and returns a 0.
January 13, 2011 at 10:39 am
First, I'd recommend you use this maintenance script. Lots of expert DBAs have reviewed it and they like it: http://sqlfool.com/2009/06/index-defrag-script-v30/
Second: This is not necessarily good advice.
after ur rebuild index/reorganize, you...
January 13, 2011 at 10:37 am
They should, and I've asked for this to be fixed. It's logged as a bug, but a low priority one. That page doesn't get many reads.
January 13, 2011 at 10:32 am
Ed has good suggestions for you.
I might also schedule a job that checks for new objects in the primary filegroup every night. Let it run and email you if there...
January 13, 2011 at 10:29 am
Viewing 15 posts - 17,086 through 17,100 (of 39,903 total)