Viewing 15 posts - 151 through 165 (of 966 total)
What is the execution policy on the machine you are trying to run this on set to?
Additionally, if you are going to call the powershell program to run a script,...
May 17, 2016 at 3:51 pm
Is it running every 15 minutes and failing, or just not running except for various times like you listed?
How many databases are setup for log shipping and are using the...
May 17, 2016 at 3:44 pm
No clue. If I had to guess it sounds like the linked server login settings are different on your dev and production boxes. I would start there. Take a look...
May 17, 2016 at 3:42 pm
Do you have a monitoring tool like SCOM or a third-party tool? That could also be pulling metrics data that you can view over time.
May 16, 2016 at 1:51 pm
And this is why I wish SSRS supported ADFS claims authentication out of the box.
If you can, a trust is the way to go. If you cannot you might need...
May 16, 2016 at 1:47 pm
When you say "it crashes", what is crashing? The entire instance of SQL Server? The query? The process the application started?
If possible can you run the following and retry the...
May 16, 2016 at 1:41 pm
Also if you have time and want to minimize your downtime as possible you can cunsider setting up something like db mirroring or log shipping beforehand.
May 12, 2016 at 1:55 pm
What I do is use a PowerShell that reads a file with directories containing SQL Server binaries (but not directories containing data/log files or any files that change often) and...
May 11, 2016 at 12:07 pm
The initial encryption can be a considerable hit, so depending on the db and application it supports you may want to do this outside of business hours.
Another couple of things...
May 9, 2016 at 12:55 pm
Was the SQL Server Management Studio you used installed on the server when SQL was installed or is it on another system connecting remotely? Is the version of SSMS running...
May 9, 2016 at 12:50 pm
You should be able to install SQL Server 2005, but you will get a pop-up a couple of times that you will need to apply a service pack right after...
May 6, 2016 at 4:33 pm
The SQL Server Release Services team sent a link to it on the Update Catalog a couple of days ago:
SQL Server 2005 end of life and upgrade options
https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2005-end-of-life-and-upgrade-options/%5B/url%5D
Microsoft SQL Server...
May 6, 2016 at 4:26 pm
Are the databases that SSMS/SSRS pointing to the same or are they different?
It wouldn't hurt to double-check the parameters in Report Manager for the report. I have seen Report Manager...
May 6, 2016 at 4:15 pm
OK, this is what's happened. I've deleted the .DATA file, but the report still won't sort the way I've specified in the SP
Are the results from the stored procedure going...
May 6, 2016 at 4:12 pm
Just a guess but is the secondary replica set to asynchronous and/or manual failover? What do you get when you run the following:
SELECT
ag.name,
r.replica_server_name,
r.availability_mode_desc,
r.failover_mode_desc
FROM
sys.availability_replicas r
INNER JOIN sys.availability_groups ag
ON r.group_id = ag.group_id
ORDER...
May 6, 2016 at 4:04 pm
Viewing 15 posts - 151 through 165 (of 966 total)