Viewing 15 posts - 61 through 75 (of 219 total)
Try “msdtc –uninstall” on all nodes and also remove the registry keys
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSDTC
HKEY_LOCAL_MACHINE\SYSTEM\Current ControlSet0\Services\MSDTC
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet1\Services\MSDTC
HKEY_CLASSES_ROOT\CID
If you are doing this on a prod, I would suggest you to take the full backup and...
July 25, 2003 at 2:35 pm
-- There is no problem with it, except the fact that it will keep getting bigger, until you re-initialize the file. I usually take log backup in to separate files...
July 25, 2003 at 2:26 pm
-- Take the backup on the Source DB and move it to the Target
-- Go to EM and choose Database-->Restore --> Select From Device-->Select Devices --> ADD --> Choose the...
July 25, 2003 at 2:01 pm
SQL Server will automatically recompiles the Stored procs and Trigger when it is necessary to do so
July 25, 2003 at 1:41 pm
You might have selected the first option in the DTS package in “Specify table COPY or Query” option. Select “Copy objects and Data between SQL Server Databases” and depending on...
July 24, 2003 at 2:00 pm
Create a test table in your database and do some dummy transactions in a loop. Then either shrink your log file or take a log backup with NO_LOG and take...
July 24, 2003 at 1:35 pm
Users with DBO rights/Sysadmin rights can put the DB into single user mode. Check with other dbo's. Alternatively run the profile and check next time your db turns in to...
July 24, 2003 at 8:53 am
You can rename in SQL 7.0. Just run the setup again, it won’t install the software but it will change the required files to recognize the new server name. Drop...
July 24, 2003 at 8:43 am
PS:Completed indicates the stored procedure has completed. RPC:Completed occurs When one instance of SQL Server send a request for another SQL Server to execute a remote procedure, the relational...
July 23, 2003 at 1:44 pm
What's your version for Ms OLE DB Provider for Oracle? Also SQL Version
July 23, 2003 at 1:18 pm
NOPE...Whats your problem
Edited by - Shas3 on 07/23/2003 1:15:08 PM
July 23, 2003 at 1:14 pm
Expanding your database from 1MB to 50GB take long time. Who many data files you have? Make sure you have enough disk space left on the drives where your data...
July 23, 2003 at 1:13 pm
Create a test table in your DB and do some dummy transactions in a loop and then backup the log with no log and then take a Full backup
July 23, 2003 at 1:06 pm
Very interesting and basic piece of information, I never really focused on this. Thanks for the info. With little research on this I found that with the undocumented DBCC LOGINFO(‘DBNAME’)...
July 23, 2003 at 1:01 pm
Viewing 15 posts - 61 through 75 (of 219 total)