Viewing 15 posts - 31 through 45 (of 217 total)
hi
I need to encrypt this windows domain account password and give Browse permission in Report manager to this user and give the URL (http://servername/reportserver) to developer. And then...
February 14, 2010 at 10:45 pm
Hi,
Did anybody create log shipping & ship the log file to secondary based on fixed size instead of every 5 mins or 15 mins? For example if the log file...
February 10, 2010 at 12:33 pm
How about creating a SQL Agent Alert that fires when the log file is bigger than 50MB ? Get it to start a job that does the log backup.
The alert...
February 10, 2010 at 12:21 am
On the weekly maintenance plan,
1. take full backup
2. Change the recovery model from full to simple
3. Then rebuild the index, ideally with SORT_in_Tempdb
5. Change the recovery model back to FULL
4....
January 28, 2010 at 12:31 pm
Is there way to control the log file siz, eLike if the log file is 50 MB, then ship to secondary in Log shipping configuration in SQL Server 2005 EE...
January 28, 2010 at 9:24 am
I found the .NET Frame work 3.5 SP1 from the below link http://msdn.microsoft.com/en-us/netframework/aa569263.aspx
But is is NOT .NET Frame work 3.5 SDK. I believe .NET Frame work 3.5 SDK...
January 27, 2010 at 8:41 pm
Thank you very much..I'm clear now
January 27, 2010 at 8:24 pm
The above collation is actually SharePoint predefined collation check the support article below for details.
http://support.microsoft.com/kb/843578%5B/quote%5D
From the above link, I understand that share point databases will be created with...
January 27, 2010 at 7:53 pm
Yes. We are currently running some SQL 2008 instances in VM
Is the Virtual server is Windows server 2008?
January 27, 2010 at 6:40 pm
Can it be done?
January 27, 2010 at 6:14 pm
So there is NO option like with NO_LOG in SQL Server while Rebuilding Indexes like we have in ORACLE?
January 22, 2010 at 5:45 pm
thanks,
log backups are happening from the Native Log shipping backup job
January 22, 2010 at 5:05 pm
I agreed with Mohammed Sort in tempdb option will use space of tempdb
If I select the option Sort results in tempdb, the log size of 12GB of MyDB database,...
January 22, 2010 at 4:49 pm
I would go so far as to increase the tlog backup interval to every 5 minutes during index rebuilds / reorgs
I have changed the log backup schedule to every 15...
January 22, 2010 at 4:39 pm
With sp_who2, I did not see any login connected to any database other than MASTER database
Sp-who2 active:
180 RUNNABLE ...
January 21, 2010 at 4:24 pm
Viewing 15 posts - 31 through 45 (of 217 total)