Viewing 15 posts - 376 through 390 (of 411 total)
There is just not enough information to give a helpful answer. I'll try.
Q1. Import what, and to where? If you are asking if the job text itself, written...
March 2, 2011 at 11:56 pm
No problem. I know it does sound strange, but auto grow is great - only as a last resort. Auto shrink is terrible and should be removed from SQL Server...
March 2, 2011 at 10:11 am
TO DISK = '\\MyComputerName\C$\MyBackUps\TestBackup.BAK'
-or-
TO DISK = '\\MyComputerName\MyBackUpsShared\TestBackup.BAK'
March 1, 2011 at 12:52 pm
Use RAID 10 instead of 5. Faster writes (about 30% or so?). Requires at least one more disk.
Use RAID 10 instead of 0+1. Same disk numbers, but better fault tolerance...
March 1, 2011 at 10:11 am
The use of AWE indicates that this is may be an x32 system with AWE enabled. When AWE is enabled, RAM is reported inaccurately in task manager or similar, however,...
March 1, 2011 at 9:59 am
Yep. Target cache hit ratio should be about 99% in most cases.
Your high cache hit shows that the ram allocated to SQL server is working great, however the high...
March 1, 2011 at 9:38 am
Paul,
You rock. Thanks for the treaure chest of info!
Jim
March 1, 2011 at 8:57 am
Paul,
No sweat man. You post kind of a lot so it is easy to have all of the threads blend together.
I'm sure you will address the CXPacket always being...
March 1, 2011 at 12:23 am
It sounds like you are using SSMS to create the backup. If you do not want to append the backup to the previous file in a set, just switch...
February 28, 2011 at 4:17 pm
Peter - there is much more too it than file system permissions. Please refer to the links in my previous post for more information.
Jim
February 28, 2011 at 4:00 pm
Paul,
Please do tell me where I misspoke. I would hate to have misinformation up to confuse people for years to come. I'd like to edit and correct anything...
February 28, 2011 at 10:46 am
Hey Peter,
There is more info about setting up a lower priv account to run SQL server here: http://msdn.microsoft.com/en-us/library/ms143504.aspx.
See this for the security risk: http://www.sqlservercentral.com/blogs/brian_kelley/archive/2009/11/13/why-we-recommend-against-xp-cmdshell.aspx
Jim
February 28, 2011 at 8:31 am
Oh good. Glad you are back up and going.
It is not possible. Under normal circumstances. Is a process/job backing up and restoring to the other instance each night? ...
February 27, 2011 at 10:19 pm
Ah, OK. Glad it's resolved.
Sounds like it was a permissions issue with that account not having permissions to the data files.
Local system is a very high priv account...
February 27, 2011 at 9:32 pm
Uh, ya. That's not normal behavior. You should bet the error you describe when attempting to attach in-use files. Almost sounds like the migration restored over top of the other...
February 27, 2011 at 8:37 pm
Viewing 15 posts - 376 through 390 (of 411 total)