Viewing 15 posts - 61 through 75 (of 231 total)
Just want to add, when you restore, you get the same free space back on the restored Db.
January 18, 2012 at 1:10 am
SQL error log should tell you which SQL account was used to run it.
January 18, 2012 at 1:05 am
How are you creating your database? is it using script or from SSMS
if it is using script ( Create database db1 ) then it still places data and log...
January 16, 2012 at 2:53 am
Shared folders can be directly accessed for restore operations as long as the account used should have rights on shared folder but the data and log files on the restored...
January 8, 2012 at 5:22 am
@jeffrey, Although that can be done fairly easily, you will definitely end up with an orphaned SPN record that could cause problems with windows authentication to SQL Server.
Shouldn't manually...
January 8, 2012 at 4:21 am
Can we have the update query and its query plan to check if it can be improved.
January 7, 2012 at 3:35 am
Is there any other error message that is shown in the error log just before this message.
Can you also enable profiler to trace any query executing sp_reset_connection / or...
January 7, 2012 at 3:30 am
If i understand you correctly you want to update the rows with status value equal to 6 with row with status value equal to 2. Then you may try
update...
January 7, 2012 at 2:18 am
Starting from sql server 2k8 username passwords are to be keyed in as anonymous authentication is disabled. Not too sure abt 3 time prompt.
January 4, 2012 at 3:06 am
are there any memory related errors on SQL error log?
What is the SQL Patch version?
Do you have perfmon or memory monitoring enabled. Does it always failover when the memory is...
January 4, 2012 at 3:02 am
Yes. 'Preferably' additional msdtc and cluster group.
January 3, 2012 at 2:54 am
New instance needs
* Dedicated IP address or SQL
* Dedicated ip address for msdtc
* Dedicated Virtual Name for SQL instance
* Dedicated Shared disks for Data and root directories
* Dedicated shared disk...
January 2, 2012 at 1:46 am
Opening the topic again as I have doubt.
Assume,I perform a quick latest filegroup restore ,bring the database online and then transactions are issued against the partial database. After few days,...
December 26, 2011 at 4:12 am
Thanks for clarifying 🙂
December 22, 2011 at 8:08 am
Just to add, Primary file group is not busy as it contains only meta data. Few selects and very very rare write activity.
December 15, 2011 at 2:39 am
Viewing 15 posts - 61 through 75 (of 231 total)