Viewing 15 posts - 136 through 150 (of 150 total)
What I do is set up performance monitor to collect this data. Check around in perfmon to see what counters you want to get a baseline of, and then...
October 31, 2013 at 1:20 pm
Looks like we may need one other log, but I don't quite know what it would be named. This is in your output
Feature: Full-Text Search
Status: Failed: see logs for...
October 31, 2013 at 1:18 pm
Well, you certainly are connecting to the LSTest instance. Why the instance name does not show up in the banner along with localhost I am not so sure. ...
October 31, 2013 at 1:13 pm
Are you trying to slipstream the install? By that, I mean install a brand new instance with SP2 installed without having to install SP2 separately?
October 31, 2013 at 9:53 am
What are you monitoring for? Performance? Availability? Security audit?
October 31, 2013 at 9:50 am
I don't think you understand me. This is not how filestream works. you need to connect to SQL Server, and insert or update the filestream enabled column. ...
It sounds like you may have a copy of SQL Express running as a named instance (LSTest), and a default instance that you are trying to upgrade. For the...
October 31, 2013 at 9:47 am
You should never try to modify/copy/manage the files in a filestream share via command line. If you inspect the properties of the share, you will find that it is...
October 31, 2013 at 9:41 am
As you have probably figured out, something happened, and the server lost sight of the backup file. When that happened, it could not continue with the restore. Is...
October 31, 2013 at 9:37 am
Run sp_update_job @job_name = 'name of job', @enabled = 1
sp_update_job @job_name = 'name of job', @enabled = 1
October 30, 2013 at 7:25 am
Assuming none of the users own schemas or objects, this will generate the commands for you. Edit as needed:
select 'drop user [' + d.name + ']'
from sys.database_principals d left...
October 29, 2013 at 11:10 am
OK, how about we have a look at what is really going on with the files in both places. Run these, and post the results:
restore filelistonly from disk ='C:\MSSQL\Backup\DEV-database'+...
October 29, 2013 at 11:06 am
If you are trying to overwrite the existing dev database, you will need to add REPLACE to your with list.
October 29, 2013 at 9:39 am
In SQL 2008 R2, you may get some more details in the errorlog.
The database he has access to is not in RESTRICTED_USER mode, by chance, is it?
October 29, 2013 at 9:33 am
Transactional replication will give you near real time updates, but there will be a few seconds delay, depending on how bad the latency is between the two sites. With...
October 28, 2013 at 12:30 pm