|
|
|
|   |
|
|
| Last week most active authors |
| No posts for a week |
|
|
|
|
|
|
|
| |
| Last active threads |
[info]Deploying outllok 2007 with bcm in a remote Database configuration
Started Azur · Date: Sep 11, 2008 02:49 ·
2 post(s) |
Huge MSDB because of logshipping
Started Shuwi · Date: Sep 16, 2008 01:03 ·
16 post(s) |
use SSMS to relocate data/log files ?
Date: Sep 15, 2008 10:47 ·
3 post(s) |
FAIL HTTP-OAI-3.20 i386-freebsd 6.1-release-p23
Started srezic · Date: Sep 12, 2008 07:26 ·
1 post(s) |
US-NY: New York-Data Center Senior Consultant (48463)
Started JobCircle.Com · Date: Sep 11, 2008 14:38 ·
1 post(s) |
US-NY: New York-Data Center Facilities Manager (48424)
Started JobCircle.Com · Date: Sep 11, 2008 14:38 ·
1 post(s) |
Re: Can BCM database be installed on a standard SQL Server
Started farouk drif · Date: Aug 26, 2008 05:55 ·
5 post(s) |
Sql Server 2005 Dev. Ed. on Windows Server 2003
Started BrianR · Date: Sep 3, 2008 05:48 ·
7 post(s) |
SQL Server 2005 Resource Database
Started Justin · Date: Sep 5, 2008 08:47 ·
8 post(s) |
Setting up a second development system
Started Andrea · Date: Sep 7, 2008 00:05 ·
1 post(s) |
|
| Last week hot threads |
| No posts for a week |
|
|
|
|
|
| Latest posts |
Re: [info]Deploying outllok 2007 with bcm in a remote Database configuration
Group: microsoft.public.outlook.bcm · Group Profile · Search for mdf in microsoft.public.outlook.bcm
Author: ThePro
Date: Sep 19, 2008 07:40
... automatically after a security update comming newly. you have to modify the property of the service connection to local system to work arround) Third step (on the computer) Locate the SmallBusiness.mdf and SmallBusiness.ldf files local database (doc&settings etc....) copy them on a directory of the destination server. (ex c:\crmdatabase) Fourth step (on the server) Start sql server management ...
Show full article (1.49Kb) |
Re: Huge MSDB because of logshipping
Group: microsoft.public.sqlserver.setup · Group Profile · Search for mdf in microsoft.public.sqlserver.setup
Author: Andrew J. Kelly
Date: Sep 18, 2008 15:53
...JeroenSchoen@discussions.microsoft.com> wrote in message news:78568E64-EC19-4316-AFDF-110330A6E344@microsoft.com... Hi Ekrem, I agree, the dbcc shrinkfile did not work, my msdbdata.mdf is still 113 GB :( There are 3 tables : 48230 MB --> log_shipping_monitor_error_detail 6106 MB --> log_shipping_monitor_history_detail Those tables are not effected by sp_cleanup_log_shipping_history or ...
Show full article (4.01Kb) |
Re: Huge MSDB because of logshipping
Group: microsoft.public.sqlserver.setup · Group Profile · Search for mdf in microsoft.public.sqlserver.setup
Author: Ekrem Önsoy
Date: Sep 18, 2008 10:03
...JeroenSchoen@discussions.microsoft.com> wrote in message news:78568E64-EC19-4316-AFDF-110330A6E344@microsoft.com... Hi Ekrem, I agree, the dbcc shrinkfile did not work, my msdbdata.mdf is still 113 GB :( There are 3 tables : 48230 MB --> log_shipping_monitor_error_detail 6106 MB --> log_shipping_monitor_history_detail Those tables are not effected by sp_cleanup_log_shipping_history or ...
Show full article (6.13Kb) |
Re: Huge MSDB because of logshipping
Group: microsoft.public.sqlserver.setup · Group Profile · Search for mdf in microsoft.public.sqlserver.setup
Author: JeroenSchoen
Date: Sep 18, 2008 06:52
..." <JeroenSchoen@discussions.microsoft.com> wrote in message news:78568E64-EC19-4316-AFDF-110330A6E344@microsoft.com... Hi Ekrem, I agree, the dbcc shrinkfile did not work, my msdbdata.mdf is still 113 GB :( There are 3 tables : 48230 MB --> log_shipping_monitor_error_detail 6106 MB --> log_shipping_monitor_history_detail Those tables are not effected by sp_cleanup_log_shipping_history or ...
Show full article (4.95Kb) |
Re: Huge MSDB because of logshipping
Group: microsoft.public.sqlserver.setup · Group Profile · Search for mdf in microsoft.public.sqlserver.setup
Author: JeroenSchoen
Date: Sep 18, 2008 06:20
..." <JeroenSchoen@discussions.microsoft.com> wrote in message news:78568E64-EC19-4316-AFDF-110330A6E344@microsoft.com... Hi Ekrem, I agree, the dbcc shrinkfile did not work, my msdbdata.mdf is still 113 GB :( There are 3 tables : 48230 MB --> log_shipping_monitor_error_detail 6106 MB --> log_shipping_monitor_history_detail Those tables are not effected by sp_cleanup_log_shipping_history or ...
Show full article (3.20Kb) |
Re: Huge MSDB because of logshipping
Group: microsoft.public.sqlserver.setup · Group Profile · Search for mdf in microsoft.public.sqlserver.setup
Author: Andrew J. Kelly
Date: Sep 18, 2008 04:42
..." <JeroenSchoen@discussions.microsoft.com> wrote in message news:78568E64-EC19-4316-AFDF-110330A6E344@microsoft.com... Hi Ekrem, I agree, the dbcc shrinkfile did not work, my msdbdata.mdf is still 113 GB :( There are 3 tables : 48230 MB --> log_shipping_monitor_error_detail 6106 MB --> log_shipping_monitor_history_detail Those tables are not effected by sp_cleanup_log_shipping_history or sp_purge_jobhistory ! So,...
Show full article (2.73Kb) |
Re: Huge MSDB because of logshipping
Group: microsoft.public.sqlserver.setup · Group Profile · Search for mdf in microsoft.public.sqlserver.setup
Author: Ekrem Önsoy
Date: Sep 18, 2008 04:29
..." <JeroenSchoen@discussions.microsoft.com> wrote in message news:78568E64-EC19-4316-AFDF-110330A6E344@microsoft.com... Hi Ekrem, I agree, the dbcc shrinkfile did not work, my msdbdata.mdf is still 113 GB :( There are 3 tables : 48230 MB --> log_shipping_monitor_error_detail 6106 MB --> log_shipping_monitor_history_detail Those tables are not effected by sp_cleanup_log_shipping_history or sp_purge_jobhistory ! So,...
Show full article (3.55Kb) |
Re: Huge MSDB because of logshipping
Group: microsoft.public.sqlserver.setup · Group Profile · Search for mdf in microsoft.public.sqlserver.setup
Author: JeroenSchoen
Date: Sep 18, 2008 00:45
Hi Ekrem, I agree, the dbcc shrinkfile did not work, my msdbdata.mdf is still 113 GB :( There are 3 tables : 48230 MB --> log_shipping_monitor_error_detail 6106 MB --> log_shipping_monitor_history_detail Those tables are not effected by sp_cleanup_log_shipping_history or sp_purge_jobhistory ! So, the main question is.. how to get rid of 100 gig of error data... when I try to run sp_purge_jobhistory to get rid o data in 47349 MB ...
Show full article (2.29Kb) |
Re: use SSMS to relocate data/log files ?
Group: microsoft.public.sqlserver.tools · Group Profile · Search for mdf in microsoft.public.sqlserver.tools
Author: Erland Sommarskog
Date: Sep 15, 2008 14:46
John A Grandy (johnagrandy-at-gmail-dot-com) writes: Sql Server 2005 : Can SSMS be reliably used to relocate data ( .mdf ) and log ( .ldf ) files ? Exactly what in SSMS did you intend to use? The Copy Database Wizard can do this for you, although "reliable" is not really the association I make when I think of CDW. Then again, the attach/detach method appears to work; it's the SMO method which is buggy. Personally, I would ...
Show full article (0.84Kb) |
Re: use SSMS to relocate data/log files ?
Group: microsoft.public.sqlserver.tools · Group Profile · Search for mdf in microsoft.public.sqlserver.tools
Author: Aaron Bertrand [SQL Server MVP]
Date: Sep 15, 2008 10:56
Personally, if you can afford downtime, I would prefer to detach the database files, then move them manually, then use CREATE DATABASE ... FOR ATTACH. On 9/15/08 1:47 PM, in article uUnQds1FJHA.828@TK2MSFTNGP03.phx.gbl, "John A Grandy" <johnagrandy-at-gmail-dot-com> wrote: Sql Server 2005 : Can SSMS be reliably used to relocate data ( .mdf ) and log ( .ldf ) files ?
Show full article (0.39Kb) |
|
|
|
