Viewing 15 posts - 16,651 through 16,665 (of 39,901 total)
This is a merge issue, and I've had it happen with systems getting merged. Typically what you have to do is allow the new parent system to determine how data...
March 11, 2011 at 12:42 pm
DAC and command prompt are not the same. DAC can be used from Management Studio. If you have it open when you start up the instance, connect with "Admin:" and...
March 11, 2011 at 12:32 pm
Sorry, for the in place upgrade, things are fine.
For the side by side move to new hardware, sp_help_revlogin will let you script logins. Once you get the script and run...
March 11, 2011 at 12:05 pm
The roles will be moved over as is. There are issues moving security to a new server, but for an in-place upgrade your logins will remain and they will map...
March 11, 2011 at 10:51 am
Did you start the SQL Server in Single user mode, and are you connecting with the DAC connection?
March 11, 2011 at 10:34 am
I usually have called myself the data janitor. Makes people laugh and disarms them a bit from the last DBA being too self-important.
March 11, 2011 at 9:41 am
Looks like 512GB right now is the high response. My friend had 1TB in a server, and was considering moving to 2TB as data sizes grow
March 11, 2011 at 9:33 am
There's no way to remove access from within the database. It's contained on the server, and the server determines access, as of SS2K8R2. If they are restoring the database, then...
March 11, 2011 at 8:54 am
My apologies. Points have been awarded back to the people that have answered and the question has been corrected.
March 11, 2011 at 8:36 am
How is the data coming in? Is this loaded through SSIS/bcp or is it in another table?
I would use Greg's statement to build the SQL I needed and then use...
March 11, 2011 at 7:38 am
Database Mail isn't a mail server. It has to route through Exchange or some other mail server to get to your inbox. The data is only stored in msdb long...
March 11, 2011 at 7:37 am
Best of luck there. 30 seems high, but it really depends on your SAN, the spindles, fiber speeds, etc.
March 10, 2011 at 8:31 pm
For SQL Server, for your mdf/ldf disks, free space on the disk drive has nothing to do with the performance of the disks. Why would it? There's no swapping out...
March 10, 2011 at 4:12 pm
There are lots of scripts on the site here. You might try searching for "restore log"
Here's one: http://www.sqlservercentral.com/scripts/T-Log/69750/
March 10, 2011 at 2:03 pm
The state and message are just standard SQL completion codes. Nothing special there.
I suspect the logic in your job step isn't correct for subsequent runs.
March 10, 2011 at 1:35 pm
Viewing 15 posts - 16,651 through 16,665 (of 39,901 total)