Viewing 15 posts - 676 through 690 (of 6,400 total)
This will give you the multiple ways in which this can be done.
November 13, 2021 at 7:23 am
Looks like the drives are not owned by the clustered role.
Verify in failover cluster manager what role owns the drive(s) you are trying to restore too.
If this is owned by...
November 13, 2021 at 7:19 am
For me the VM should be backed up after SQL especially if your backing up to local disk. That way the VM backup will backup the backup files to tape/some...
November 11, 2021 at 8:34 pm
Task scheduler or a full blown sql server which has batch files to connect to the sql express instance and back it up run via the agent.
November 11, 2021 at 8:30 pm
You cannot use the same SSRS database for multiple installations of SSRS (unless its a scale out farm)
You can however create multiple SSRS databases
ReportServer
ReportServer_Customer1
ReportServer_Customer2
And then have 3 different SSRS portals...
November 4, 2021 at 2:50 pm
VS 2015 is the minimum for 2016 if I remember correctly.
You then need the right version of SSDT for VS 2015.
But given you can use VS2019 community and the latest...
November 3, 2021 at 4:05 pm
Just grant execute to the proc and nothing else, no other role memberships, no read, no write etc just 1 plain execute
GRANT EXECUTE ON [TheOneSproc] TO [MrOneSproc]
Then they can use...
November 3, 2021 at 3:09 pm
Have you verified you actually have free space in the database?
Have you factored in the space required to rebuild the biggest index? You’ll need at least double the space.
When it’s...
November 3, 2021 at 2:13 pm
You can use VS2019 with the latest SSRS add on to author reports for SQL2016 no problems.
November 3, 2021 at 7:25 am
Do not use the Failover Cluster Manager to move availability groups to different nodes or to fail over availability groups. The Failover Cluster Manager is not aware of the synchronization...
November 3, 2021 at 7:22 am
How frequent are the log backups and how long do they take to restore?
If you can manually log ship throughout the day, then you can take that final log and...
October 28, 2021 at 7:35 pm
Is it causing you query performance problems?
If yes rebuild statistics
If yes and rebuild statistics didn't work rebuild index
If no leave it
This day and age you want to be more concerned...
October 26, 2021 at 3:56 pm
Given that both 2008 and the native client are all depreciated you run it all at your own risk.
Even the latest native clients are depreciated in favour of the new...
October 26, 2021 at 2:55 pm
Verify and does the log get written to a folder called LOG or LOG_COPY_ONLY.
Also verify that @copy_only on the procedure code is set to N.
Also verify what the log_wait_reuse_desc is...
October 26, 2021 at 11:55 am
How are you calling the log backup with Ola’a code?
Are you doing the @copy_only = ‘y’
October 26, 2021 at 8:29 am
Viewing 15 posts - 676 through 690 (of 6,400 total)