Hi,
how did you rebuild the index. With a maintenance plan, or with some scripts from Ola Hallengren?

In this script are some values, to control the script, not...

Hi,
do you realy mean sql server 2000?

On the sql server 2016 you could use something like this:

SELECT * FROM backupset

There are...

Hi,
if you like powershell, this link could help you to :
https://dbatools.io/functions/
Kind regards,
Andreas

Hi,
I would use something like this:
C: => OS files
D: => sql binary
E: => tempdb
F: => mdf files
G: => ldf files
H: => maybe...

Hi,
can you try the solution from this link:
https://social.technet.microsoft.com/Forums/office/en-US/7a76f12e-f561-488b-91ad-2d3978011031/event-1196-failoverclustering-cluster-dns-request-not-supported-by-name-server?forum=Exch2016GD
There are some screenshots, maybe this could help you.
Kind regards,
Andreas

Hi,
did the cleanjob fail if you try to execute as a user, or did the job fail, if you try to schedule the job?

Hi,
if you would  use powershell, there are some usefull scripts:
https://dbatools.io/
Kind regards,
Andreas

Hi,
did you backup a "normal" database, or some database from "AlwaysOn"?
Did the error raise on every node from your AlwaysOn Group?

Hi,
please check if IFI is enabled (https://www.brentozar.com/blitz/instant-file-initialization/9
If you had to growth your databases, it would be faster on the mdf files, if IFI is enabled.

Hm,
is this a virtuell server, then you can some space to your harddrive without stopping sql server services. If this is real server, you had to stop sql server...

Hi,
does the stored procedure creates some result if you run it on the server 2, without linked server?
And, what kind of stored procedure do you use, maybe the...

Hi,
did you  for real use just 200 MB  at 4  tempdb files?
I think, this is not much place to work for a sql server?
Kind regards,
Andreas

Hi,
"it depends". We used transactional  replication for a database  from about 400 GB.
We had a separate distribution server, because we had about 12 replications over all.
For...

HI,
you can think about replication, we used this for reporting .
Kind regards,
Andreas

Hi,
wich version of VEEAM are you using. I think, only the new version of VEEAM is able to restore singel files. In case of emergency, maybe it  is required,...