Viewing 15 posts - 1,021 through 1,035 (of 6,400 total)
You would set the expression of the FileName property or the ConnectionString property which ever you are building to be that of the parameter either at package or project level...
July 20, 2020 at 6:54 am
What version of DBATools do you have installed?
Should be 1.0.114, you should be keeping this up to date.
With everything that's going on with the BLM movement, terms like master have...
July 17, 2020 at 10:39 am
Will be down to the proportional fill algorithm thats used.
Adding a data file to an existing filegroup is generally not done due to this.
What would of been best is to...
July 9, 2020 at 2:35 pm
Query the catalog table in the ReportServer database that will give you what has been deployed to the web interface, but remember some things may have come from other projects...
July 9, 2020 at 9:47 am
You would need to add a check to the sysjobhistory table in the MSDB database for the job you kicked off and check the status on it. If its a...
July 6, 2020 at 11:54 am
Probably not a very good situation to be dealing with. Are both products compatible with each other? How is each product doing backups? Do they use the VSS writer, are...
July 6, 2020 at 9:09 am
You would want to look at default traceflags and other options also which can be done at the operating system level.
I would recommend getting a trial version of Aireforge (https://www.aireforge.com/)...
July 6, 2020 at 9:03 am
Is this a concern about availability?
If so moving it to its own standalone server from a shared standalone server isn't going to do anything better for you.
If the server is...
July 2, 2020 at 4:44 pm
You may just have to reconfigure the setting
sp_configure 'show advanced options',1
go
reconfigure
go
sp_configure 'Agent XPs',1
go
sp_configure 'show advanced options',0
go
reconfigure
go
If not can you try to start the agent and then supply...
June 30, 2020 at 7:45 am
.net 3.5 still has a number of years left on mainstream and even extended support with Microsoft as long as you install .net3.5 SP1
https://support.microsoft.com/en-gb/lifecycle/search?alpha=.net%20framework%203.5
Hell it has a longer life span...
June 29, 2020 at 8:30 am
The error seems to suggest that the login doesn’t exist at the SQL level.
which account performed the installation?
can you login as that account and add in the users you need?
otherwise...
June 26, 2020 at 6:19 pm
On the exams website is a preparation section, within that section are the ONLY authorized items which can be used for study and practise.
Within that section for 70-761 you will...
June 20, 2020 at 6:11 am
You talking about a true FCI here shared disk setup? Not an availability group setup?
If it is a FCI shared disk etc then the service is only ever running from...
June 19, 2020 at 8:54 am
You will need to speak to your windows admin team.
CHECK_POLICY = ON will force the user to use the DOMAIN POLICY for password.
So complexity requirements, length of password, minimum age...
June 19, 2020 at 8:47 am
Should also be renaming the DB, as a select query on an old connection string could still access the database.
June 18, 2020 at 3:39 pm
Viewing 15 posts - 1,021 through 1,035 (of 6,400 total)