Viewing 15 posts - 316 through 330 (of 545 total)
including all other information, you should also study this: http://www.directionsonmicrosoft.com/sample/DOMIS/update/2008/06jun/0608pmccu.htm
July 5, 2008 at 7:09 am
you have to/can define a path when you write a differential plan.
Also if i am reading correct are you trying to create backps of the master DB?
July 4, 2008 at 3:30 pm
Check the PAE switch in Boot.ini and Enable AWE in sql, with locked pages in memory using local security settings MMC.
July 4, 2008 at 8:46 am
The select into wont carry over the Keys/Indexes.. even you have to redo the IDENTITY Field.
IMPORT/EXPORT is the best method for a Quick Table Move.
July 4, 2008 at 8:44 am
Before doing anything:: Backup the SP and Table Structures from Production as a roll back procedure.
right click on the procedure name then click modify.. change the connection to point to...
July 4, 2008 at 8:25 am
Take a current backup of the Production Database.
Make sure you dont have any IMP Code changes(SP/Tables/Functions) in the Development/TEST Environment beore doing the RESTORE.
Backup the Development Database aswell.
Then copy the...
July 4, 2008 at 8:21 am
did you Login using Administrator Authentication, before running the Memory Counters.
July 3, 2008 at 8:10 pm
yes correct, Use BCP, if you have Heavy data Loads.
July 3, 2008 at 7:25 pm
Not all of the tools are cluster-aware, in this regard Integration Services, Reporting Services & Notification Services (if used) will be installed on the first node where setup runs. So...
July 3, 2008 at 7:22 pm
Windows 2003 standard edition, should be good enough. Also check out different flavors of SQL Express Editions. http://www.microsoft.com/sql/editions/express/comparison.mspx
Also , if you are considering using the advanced features like...
July 3, 2008 at 7:07 pm
YES True, and that is what the Default Database Setting is ment to be. But as it stands, More Freedom, more issues. So i personally Stopped the usernames getting their...
July 3, 2008 at 6:39 pm
Well good Question and will be a good discussions:
so here is my start and 2 cents:
The Local System option specifies a local system account that does not require a password...
July 3, 2008 at 6:13 pm
you will have to run this on the production database and not on the backup database. because that is the source of the issue.
See if you can get a outage...
July 3, 2008 at 5:16 pm
Yes the DBCC commands are essential to check your Database integrity after the move. and the UPDATEUSAGE will help to rearrange the pages.
Also if Possible REINDEX and stastics as Gila...
July 3, 2008 at 2:44 pm
Well i think everybody should start using the schema based Sepration Procedures for all objects. that will also be helpful in distinguishing the Objects and relate them to specific...
July 3, 2008 at 2:41 pm
Viewing 15 posts - 316 through 330 (of 545 total)