Vidhya has a good procedure. You can also detach the files, copy them with new names, and attach them to the new instance.

Note this doesn't move logins, so you might...

Log backups have nothing to do with full backups. that is why you need to take log backups in addition to full backups.

If you are in simple mode, there's nothing...

Is this VB6? Are you stepping through the code? Is this the same workstation that ran them from EM?

That message usually indicates a network level error, the server address is...

I think this is generally the case, though I do see some database developer positions at times and there are plenty of DBAs that do database development work and don't...

Haven't seen that. Is that the case with every maintenance plan you create?

Gail is correct. You need enough space to reindex, and if you shrink, you might undo all the efforts you've done in reindexing as a shrink might move things around.

Leave...

Please post the script. I understand you're a new DBA, but you're not giving us enough of a picture.

Can you log in as SA and try the job?

Anything that is...

It's not clear what you want. Please explain what you want to do, and break your sentences so we can understand the process you want to consider.

If you want to...

It could be a disk issue, then. It isn't a large database, so even on a workstation, it shouldn't take that long. If you run an ad hoc backup, is...

There are complicated ways, but honestly I'd just use a dates table, since then you can account for holidays, weekend work, etc. in that table. I'd actually use the dates...

Often there's some OS error, maybe file not available or something like that, which causes suspect mode. The error log often pinpoints this, so post the error, as suggested above,...

Is the job still doing something? Is it still running or is it running for 12 hours continuously?

I'd run a trace to be sure that something didn't get hung up...

There's not enough information here. What was the difference between the scenarios or was this just two different tests?

I could guess that the first time it's possible that your secondary...

You need a subquery to get the top 5. You could use a CTE as well or a view.

Basically get the top 5 records

select top 5 xx from table yyyyy...

What's the Error number? It sounds like a hardware issue on your system. are backups completing?